Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Disable Menu and command buttons
You can hide them
i = 0 for each cb in Application.CommandBars i = i + 1 if i < 3 then cb.Enabled = False else cb.Visible = False End if Next Application.DisplayFormulaBar = False You need to make a list so you can restore them to their previous state. Regards, Tom Ogilvy "Soniya" wrote in message ... Hi All, Is there a way to disable (gray out) all Excel Munus and command buttons (selected or all)in the active workbook only (under workbook activate) TIA Soniya |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
copy command is disable under edit menu | Excel Discussion (Misc queries) | |||
how to disable copy paste buttons from from edit menu | Excel Discussion (Misc queries) | |||
disable built-in menu and short-cut key for cut command | Excel Discussion (Misc queries) | |||
How disable menu command on excel view | Excel Discussion (Misc queries) | |||
How disable menu command | Excel Discussion (Misc queries) |