Home |
Search |
Today's Posts |
|
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
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! |
#2
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
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! |
#3
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
Perfect. Thnx!
*** Sent via Developersdex http://www.developersdex.com *** Don't just participate in USENET...get rewarded for it! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
How do I turn scroll lock off (2007 excel)? No scroll lock key | Excel Discussion (Misc queries) | |||
How to lock the Ctrl key? (as locking the Shift key w/Caps Lock) | Excel Discussion (Misc queries) | |||
how do I undo the scroll lock, thscroll lock button does not work | Excel Discussion (Misc queries) | |||
I have lock a wookbook but one cell does not want to lock it | Excel Discussion (Misc queries) | |||
I have lock a wookbook but one cell does not want to lock it | Excel Discussion (Misc queries) |