View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Bob Phillips[_6_] Bob Phillips[_6_] is offline
external usenet poster
 
Posts: 11,272
Default diabling the worksheet menu bar?

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

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)

"Rich Cooper" wrote in message
...
Is it possible to disable the worksheet menu bar and also when a use right
clicks on it disable the popup menu allowing a use to add or remove a
toolbar. Can either or both be disabled?