![]() |
lock customize bar
I built my own Menu Bar and use:
Application.CommandBars("Standard").Enabled = False to avoid unwanted changes. But right click on menu bar still let users to add buttons and customize it. Any help on how to get rid of "customize" option, or at least lock it out. Thanks! |
lock customize bar
You can use the .Protection property to decide what you want the users to do
or not to do with the commandbar. -- Regards, Juan Pablo González "Daniel" wrote in message om... I built my own Menu Bar and use: Application.CommandBars("Standard").Enabled = False to avoid unwanted changes. But right click on menu bar still let users to add buttons and customize it. Any help on how to get rid of "customize" option, or at least lock it out. Thanks! |
lock customize bar
Perfect. Thnx!
*** Sent via Developersdex http://www.developersdex.com *** Don't just participate in USENET...get rewarded for it! |
All times are GMT +1. The time now is 12:06 AM. |
Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com