I believe when Excel is not shut down normally the auto_close sub does not run.
The usual place to put code that you want to run when a workbook opens/closes
is the ThisWorkbook...Workbook_Open and Workbook_Close event subs.
You had better give those a try. By the way those are also not infallible.

You probably ought to put the menu bar enabled = true code in both.the
Auto_Close and Workbook_Close subs.
--
Jim Cone
Portland, Oregon USA
http://www.realezsites.com/bus/primitivesoftware
(Excel Add-ins / Excel Programming)



"dim"
wrote in message
Hi Jim, thanks for the reply.
This is the main user interface workbook, and any relevant code within it
executes using the RunAutoMacros command.

My problem is if people run this workbook when they have no other workbook
open. Then if it goes pear shaped, this is the only instance of Excel. I
can't really tell people that they have to open Excel, minimise the window,
then open Excel again and run my workbook, its not practical. :-(

Do you have any idea why re-opening and then closing my workbook doesn't
reset the toolbars in some cases?
Thanks.
"Jim Cone" wrote: