Resetting menu option on close...
 

Did you create a custom toolbar names "Sheet"?

--
Regards,
Tom Ogilvy


"alanleecohen" wrote in message
...
I use a Usrform to logon and to prevent unhiding sheets i use the
following code -
CommandBars("Sheet").Enabled = True.

However when I close the workbook the same code (that i've placed in the
ThisWOrkbook Workbook_Before_Closed event gives me the following error...

Error '91" Object variable or With block not set...

What am I missing...:)?