Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Toolbars & command disabled
I found the following code that works great for me in that it disables right
click and all toolbars for the workbook on startup. Is there any way to enable only certain right click functions. I have radio buttons that a user will click on and I would like to keep "clear contents" available only. Sub Commands() Dim oCB As CommandBar For Each oCB In Application.CommandBars oCB.Enabled = False Next oCB End Sub |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Toolbars & command disabled
Any takers on this one? It would be a good alternative for me since I can't
seem to find a solution to reseting a radio button by just clicking. "dgold82" wrote: I found the following code that works great for me in that it disables right click and all toolbars for the workbook on startup. Is there any way to enable only certain right click functions. I have radio buttons that a user will click on and I would like to keep "clear contents" available only. Sub Commands() Dim oCB As CommandBar For Each oCB In Application.CommandBars oCB.Enabled = False Next oCB End Sub |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Toolbars and Command Language | Excel Discussion (Misc queries) | |||
Unable to use right-click on cells; standard and formatting toolbars disabled | Excel Discussion (Misc queries) | |||
VBA IDE Menus and Toolbars are all disabled | Excel Programming | |||
Why are my auditing and forms toolbars disabled? | Excel Discussion (Misc queries) | |||
Preventing shortcut keys from working on disabled toolbars | Excel Programming |