Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Opposite of Auto_Open
What is the opposite of Auto_Open ie a macro that runs as
a workbook closes.? Many Thanks Paul Moles |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Opposite of Auto_Open
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 Moles" wrote in message ... What is the opposite of Auto_Open ie a macro that runs as a workbook closes.? Many Thanks Paul Moles |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Opposite of Auto_Open
Paul,
Not surprisingly it is called Auto_Close. -- Cordially, Chip Pearson Microsoft MVP - Excel Pearson Software Consulting, LLC www.cpearson.com "Paul Moles" wrote in message ... What is the opposite of Auto_Open ie a macro that runs as a workbook closes.? Many Thanks Paul Moles |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
AUTO_OPEN | Excel Discussion (Misc queries) | |||
Auto_open and more.... | New Users to Excel | |||
Auto_open and more.... | New Users to Excel | |||
Auto_open | Excel Discussion (Misc queries) | |||
auto_open? | Excel Discussion (Misc queries) |