How to run macros as one close a excel?

  • Thread starter Thread starter Hashmi
  • Start date Start date
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
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Run Macro If Cell have "x" value 0
Macro to generate powerpoint slides 43
Need help on VBA excel macro and API to close an external application 0
Macros problem closing another file 0
How to code macro to close Excel Application? 4
Run powerpoint macro in excel 2
Run macro before closing Excel 2007 4
stop long running macro which call dll 2

Back
Top