Thread: How to run macros as one close a excel?
View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.programming
Mike H Mike H is offline
external usenet poster
  
Posts: 11,501
Default How to run macros as one close a excel?
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?
Reply With QuoteReply With Quote