| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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? |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Disable Items in Menubar | Excel Discussion (Misc queries) | |||
| Menu items added with menu item editor in older versions | Excel Discussion (Misc queries) | |||
| Disable menu items with VBA | Excel Programming | |||
| Menu Items and Disable/Enable in Excel 2003 | Excel Programming | |||
| HELP - How do I disable Excels menu items so others can't use | Excel Programming | |||
Linear Mode
