closing workbook

  • Thread starter Thread starter Sam Dickins
  • Start date Start date
S

Sam Dickins

hello people,

in my workbook code, I can make things happen when the
book starts up using...
Private Sub Workbook_Open()

It may be a simple question, but how do I do the opposite
for when the workbook closes?

thanks a lot you clever folk,

Sam
 
Sam,

You can use the Workbook_BeforeClose event procedure, or you can
name a macro Auto_Close.


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com
 
Back
Top