ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   diabling the worksheet menu bar? (https://www.excelbanter.com/excel-programming/298351-diabling-worksheet-menu-bar.html)

Rich Cooper

diabling the worksheet menu bar?
 
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?



Bob Phillips[_6_]

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?






All times are GMT +1. The time now is 06:48 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com