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

have you tried:

application.screenupdating=false
workbook_beforeclose
activeworkbook.close
application.screenupdating=true

"Peter Rooney" wrote:

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

No, Excel didn't seem to like that,
It gave me "Sub or Function not defined"

Thanks anyway

Pete



"Vacation's Over" wrote:

have you tried:

application.screenupdating=false
workbook_beforeclose
activeworkbook.close
application.screenupdating=true

"Peter Rooney" wrote:

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

There is no reason it shouldn't run unless you have disabled events.

--
Regards,
Tom Ogilvy

"Peter Rooney" wrote in message
...
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

Tom,

I'll take a look at what I've disabled & get back to you on Monday - it's
home time - yippee!

Have a good weekend

Pete



"Tom Ogilvy" wrote:

There is no reason it shouldn't run unless you have disabled events.

--
Regards,
Tom Ogilvy

"Peter Rooney" wrote in message
...
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