MrExcel Publishing
Your One Stop for Excel Tips & Solutions

SAVE MACRO??


Posted by Mike on August 16, 2000 6:09 AM

is there a macro similar to the workbook_open () macro that will run automatically when i close the program. (to reset all the changes i made in the workbook_open macro)
thanks!miek


Posted by Ryan on August 16, 0100 7:18 AM

Mike,

THere is the workbook_beforeclose() procedure. But be careful b/c if the user cancels the closing of the workbook the procedure still runs! Check out John's page here:
http://www.j-walk.com/ss/excel/tips/tip78.htm
This has a great way around the problem! Hope this helps.

Ryan