View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Peter Rooney Peter Rooney is offline
external usenet poster
 
Posts: 325
Default Workbook_BeforeClose change event not running correctly

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