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...:)?
|