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
|