Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
closing workbook
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
closing workbook
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 "Sam Dickins" wrote in message ... 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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Closing a workbook | Excel Discussion (Misc queries) | |||
Closing a protected workbook | Excel Discussion (Misc queries) | |||
Closing only one excel workbook | Excel Discussion (Misc queries) | |||
Closing a workbook upon opening another | New Users to Excel | |||
Help with closing down a workbook?? | Excel Worksheet Functions |