<div>
Put this in the workbook module. &nbsp;Change MyMacro to the name of the procedure you want to call.<br />
<br />

<pre><code id="code-20-36895629-1">Private Sub Workbook_BeforeSave(ByVal SaveAsUI As Boolean, Cancel As Boolean)
    Call MyMacro
End Sub</code></pre>
<br />
Kyle
</div>


Put this in the workbook module.  Change MyMacro to the name of the procedure you want to call.



Private Sub Workbook_BeforeSave(ByVal SaveAsUI As Boolean, Cancel As Boolean)
    Call MyMacro
End Sub


Kyle

<div>
also see<br />
<br />
<a href="http://www.ozgrid.com/forum/showthread.php?t=63563&page=1" rel="ugc">http://www.ozgrid.com/forum/showthread.php?t=63563&page=1</a><br />
<br />

</div>


also see

http://www.ozgrid.com/forum/showthread.php?t=63563&page=1 [http://www.ozgrid.com/forum/showthread.php?t=63563&page=1]



<div>
The suggested code doesn't work. &nbsp;I put a breakpoint and it skips the routine. &nbsp;Any suggestion?
</div>


The suggested code doesn't work.  I put a breakpoint and it skips the routine.  Any suggestion?

Q-27375108-1.jpg

<div>
<div class="content wysiwyg-content">
How do I call a macro each time I save a workbook?
</div>
</div>


How do I call a macro each time I save a workbook?

Execute code on Save

Microsoft Office is an integrated suite of applications that includes Outlook, Word, Excel, Access, PowerPoint, Visio and InfoPath, along with a number of tools to assist in making the individual components work together. Coding within and between the projects is done in Visual Basic for Applications, known as VBA.

Microsoft Office

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