Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
I have customised my Worksheet menu so that the "File" command is disabled
completely. To close, I have added a custom menu running a simple macro called "CloseMe", containing the command "activeworkbook.close" However, when I close in this way, my Workbook_BeforeClose (which restores the Worksheet Menu Bar and Toolbars) doesn't run. If re-enable the standard File Close command, and close this way it runs OK. Is there any way in which I can force my BeforeClose macro to run when the workbook is closed down via the first method, without having to add all the BeforeClose commands to the "CloseMe" macro? Thanks in advance & have a good weekend Pete |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Data don't enter correctly in Excel 2002 running under Vista | Excel Discussion (Misc queries) | |||
Workbook_BeforeClose event is not canceled | Excel Programming | |||
Detecting a cancel on Workbook_BeforeClose event? | Excel Programming | |||
Workbook_Beforeclose vs BeforeClose Event | Excel Programming | |||
Workbook_BeforeClose Event | Excel Programming |