Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Personal.xls and Workbook_BeforeClose
I have created the Personal.xls worksheet to run macros everytime a Excel
document is openned. The problem now is that the Procedure Workbook_BeforeClose don't run when I, for example, exit Excel by clicking in the "red cross" (Windows XP). The same happens with the Procedure Workbook_BeforeSave when I order to save. I don't understand why this happens. I need to run these Procedures when I close any Excel document or when I close the Excel application. Thanks in advance Rui Ãlvares |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Personal.xls and Workbook_BeforeClose
You'll probably need to use application level events. See
http://www.cpearson.com/excel/AppEvent.htm for details and example code. -- Cordially, Chip Pearson Microsoft MVP - Excel Pearson Software Consulting, LLC www.cpearson.com "Rui Alvares" <Rui wrote in message ... I have created the Personal.xls worksheet to run macros everytime a Excel document is openned. The problem now is that the Procedure Workbook_BeforeClose don't run when I, for example, exit Excel by clicking in the "red cross" (Windows XP). The same happens with the Procedure Workbook_BeforeSave when I order to save. I don't understand why this happens. I need to run these Procedures when I close any Excel document or when I close the Excel application. Thanks in advance Rui Álvares |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
workbook_beforeClose | Excel Programming | |||
Workbook_BeforeClose | Excel Programming | |||
Personal.xls & Workbook_BeforeClose | Excel Programming | |||
Workbook_BeforeClose | Excel Programming | |||
Workbook_BeforeClose | Excel Programming |