Thread: VB code changed Excel settings for all worksheets
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Ron de Bruin Ron de Bruin is offline
external usenet poster
  
Posts: 11,123
Default VB code changed Excel settings for all worksheets
Hi JenniferMc

Open Excel
Alt-F11
Insert module
Paste the sub
Alt-Q

Alt-F8
Select test
Run

Sub test()
Application.CommandBars("Worksheet Menu Bar").Enabled = True
End Sub



--
Regards Ron de Bruin
http://www.rondebruin.nl



"JenniferMc" wrote in message ...
I used the following vb code in a file to disable a the menu items. Now
every time I open Excel the Menu is not there.
Green around the gills with vb. What did I do wrong?

Application.CommandBars.("Worksheet Menu Bar").Enabled = False


Reply With QuoteReply With Quote