ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   lock customize bar (https://www.excelbanter.com/excel-programming/295936-lock-customize-bar.html)

Daniel[_9_]

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!

Juan Pablo González

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!




Daniel Busquet

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