How to run macros as one close a excel?

In the ThisWorkbook Module:

Code:
--------------------

Private Sub Workbook_BeforeClose(Cancel As Boolean)
'MY MACRO
End Sub

--------------------


--
Simon Lloyd

Regards,
Simon Lloyd
'The Code Cage' (http://www.thecodecage.com)
------------------------------------------------------------------------
Simon Lloyd's Profile: http://www.thecodecage.com/forumz/member.php?userid=1
View this thread: http://www.thecodecage.com/forumz/sh...ad.php?t=49704

Hi,

In VB editor double click 'This Workbook' and paste this iin on the right
and enter your code.

Private Sub Workbook_BeforeClose(Cancel As Boolean)
'do things
End Sub

Mike

"Hashmi" wrote:

How to run macros as one close a excel?