I have written a macro that I use a lot and I always use it when I am closing
the document. Is there a way that I can have the macro run automticly when I
close the document?

Right click the Excel icon on the menu bar at the top left and select view
code. This will take you to the VBE window in the ThisWorkbook module. There
are 2 drop downs menus just abopve the code window. One will say general and
the other declarations. Chnge the one that says general to Workbook. Now the
one that said declarations will show you all of the workbook events that you
can use. Select BeforeClose and a code stub will be added, something like this

Private Sub Workbook_BeforeClose(Cancel As Boolean)
'Call MyMacro 'Add your code here
End Sub
--
HTH...

Jim Thomlinson


"Precise Eng" wrote:

I have written a macro that I use a lot and I always use it when I am closing
the document. Is there a way that I can have the macro run automticly when I
close the document?

Use the workbooks BeforeClose event to call your macro.

See Chip Pearson's Overview page on events
http://www.cpearson.com/excel/events.htm

You would go to the VBE, in the project explorer, under your workbook, right
click on Thisworkbook and select view code. At the top of the module will be
two dropdowns. From the left dropdown, select Workbook and from the right
dropdown Select BeforeClose. (or you might want to use BeforeSave - only you
would know which is correct)

this will put in the declaration for the procedu

Private Sub Workbook_BeforeClose(Cancel As Boolean)

End Sub

You would call your macro he

Private Sub Workbook_BeforeClose(Cancel As Boolean)
Mymacro
End Sub

--
Regards,
Tom Ogilvy

"Precise Eng" wrote:

I have written a macro that I use a lot and I always use it when I am closing
the document. Is there a way that I can have the macro run automticly when I
close the document?