Opposite of Auto_Open
What is the opposite of Auto_Open ie a macro that runs as
a workbook closes.? Many Thanks Paul Moles |
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 |
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 |
All times are GMT +1. The time now is 12:42 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com