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