Opposite of Auto_Open

  • Thread starter Thread starter Paul Moles
  • Start date Start date
P

Paul Moles

What is the opposite of Auto_Open ie a macro that runs as
a workbook closes.?

Many Thanks


Paul Moles
 
Paul, here it is

Private Sub Workbook_BeforeClose(Cancel As Boolean)
'your code here
End Sub


--
Paul B
Always backup your data before trying something new
Using Excel 2000 & 97
Please post any response to the newsgroups so others can benefit from it
** remove news from my email address to reply by email **
 
Paul,

Not surprisingly it is called Auto_Close.


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com (e-mail address removed)
 
Back
Top