Run macro when file closes

  • Thread starter Thread starter Patrick C. Simonds
  • Start date Start date
P

Patrick C. Simonds

I need to run a macro every time my workbook close. Can this be done?
 
in the vb editor, double click the "thisworkbook" entry under microsoft excel
objects and select workbook from the dropdown and then before close from the
event dropdown

Private Sub Workbook_BeforeClose(Cancel As Boolean)
' your macro
End Sub

or use

sub auto_Close()
' your macro
end sub

in a general module
 
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
closing another file by code causes failure to run workbook activate event 2
Schedule a macro on a specific time 4
Opening a list of Excel files and run a macro in each 17
How to Unlock Excel Workbook protected by MACRO Password 6
MACRO TO COUNT ALL OPEN WORKBOOKS and print 1
Copy & Paste from One Workbook to a Macroed Template Workbook 1
Run powerpoint macro in excel 2

Back
Top