Is is possible to disable certain menu items
 

Is is possible to disable certain menu items using VBA so that when a
workbook is opened, the menu item is disabled until a password is entered?

Is is possible to disable certain menu items
 

Yes.Set the Enabled property to False

Application.Commandbars.FindControl(Id:=30007).Ena bled=False

--

HTH

RP
(remove nothere from the email address if mailing direct)


"Buster" wrote in message
...
Is is possible to disable certain menu items using VBA so that when a
workbook is opened, the menu item is disabled until a password is entered?