Posted to microsoft.public.excel.misc
|
|
Set macro to run automatically when closing workbook?
"mr_teacher" wrote:
Yes it's possible,
Go to the Visual Basic Editor, select This Workbook by double
clicking.
In the box that appears on the left hand side select Workbook and on
the right hand side select BeforeClose
Then put your macro code inbetween this and it will run before you
close the worksheet.
Hope this does what you're after
Regards
Carl
--
mr_teacher
------------------------------------------------------------------------
mr_teacher's Profile: http://www.excelforum.com/member.php...o&userid=34352
View this thread: http://www.excelforum.com/showthread...hreadid=569937
|