<div>
You probably want to add a couple of lines to Neeraj's code so that you don't get asked about saving the workbook on every change.<br />

<pre><code id="code-20-41807310-1">Private Sub Workbook_SheetChange(ByVal Sh As Object, ByVal Target As Range)
Application.EnableEvents = False
Application.DisplayAlerts = False
ThisWorkbook.Save
Application.DisplayAlerts = True
Application.EnableEvents = True

End Sub</code></pre>
</div>


You probably want to add a couple of lines to Neeraj's code so that you don't get asked about saving the workbook on every change.


Private Sub Workbook_SheetChange(ByVal Sh As Object, ByVal Target As Range)
Application.EnableEvents = False
Application.DisplayAlerts = False
ThisWorkbook.Save
Application.DisplayAlerts = True
Application.EnableEvents = True

End Sub

<div>
@Martin<br />
While simply saving the workbook, you won't get any alert. You get alert while you close the workbook without saving it first and you are asked to save the changes or not. Am I wrong?<br />
Or I am missing something here?
</div>


@Martin
While simply saving the workbook, you won't get any alert. You get alert while you close the workbook without saving it first and you are asked to save the changes or not. Am I wrong?
Or I am missing something here?

<div>
@Excel is Magic: Ignore my post. Neeraj is correct.
</div>


@Excel is Magic: Ignore my post. Neeraj is correct.

<div>
<div class="content wysiwyg-content">
Hi,<br />
<br />
i need help with VBA code.<br />
<br />
how can i have a workbook event code that whenever any cell in any worksheet of thisworkbook is changed then workbook is automatically saved.<br />
<br />
thanks.
</div>
</div>


Hi,

i need help with VBA code.

how can i have a workbook event code that whenever any cell in any worksheet of thisworkbook is changed then workbook is automatically saved.

thanks.

excel vba help, how to trigger workbook change event, if anycell is changed then automatically save workbook

Microsoft Excel topics include formulas, formatting, VBA macros and user-defined functions, and everything else related to the spreadsheet user interface, including error messages.