Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Disable 'Add or Remove buttons' functionality on a toolbar
Hello everybody,
I would like to disable the functionality to customize the excel environment. Now the only thing I'm not able to disable is the small arrow on the right of each toolbar that enables you to add or remove buttons. Does anyone has any ideas ? Thanks, Guy Van der Sande |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Disable 'Add or Remove buttons' functionality on a toolbar
Don't think you can do that...
However, you can disable its functionality via: Sub fixTBs() On Error Resume Next For Each x In CommandBars x.Protection = msoBarNoCustomize Next End Sub Now, even tho there's access to adding buttons, you'll see that nothing works! When done, try this: Sub fixTBs() On Error Resume Next For Each x In CommandBars x.Protection = msoBarNoProtection Next End Sub Bob Umlas Excel MVP "Guy Van der Sande" wrote in message ... Hello everybody, I would like to disable the functionality to customize the excel environment. Now the only thing I'm not able to disable is the small arrow on the right of each toolbar that enables you to add or remove buttons. Does anyone has any ideas ? Thanks, Guy Van der Sande |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
enable/disable multiple buttons | Excel Discussion (Misc queries) | |||
Two questions, how do I disable ver 4 macros and how do I make radial buttons like this? | Excel Worksheet Functions | |||
saving toolbar buttons on custom toolbar | Excel Programming | |||
Disable Menu and command buttons | Excel Programming |