View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Tom Ogilvy Tom Ogilvy is offline
external usenet poster
 
Posts: 27,285
Default 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...:)?