Thread: How to run macros as one close a excel?
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Simon Lloyd[_970_] Simon Lloyd[_970_] is offline
external usenet poster
  
Posts: 1
Default 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

Reply With QuoteReply With Quote