Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Menu Items and Disable/Enable in Excel 2003
I have a question about referencing menu items in VBA using Excel
2003. My workplace intranet has disabled ("grayed out") certain default menu items on the Worksheet Menu Bar. I want to enable those menu items. I see various examples that reference menu items (on the Worksheet Menu Bar) as such: Application.CommandBars("Worsheet Menu Bar").Controls("Tools").Controls("Customize").Enab led = False When I try to type this code in Excel 2003, the second reference to Controls is not available. In other words, I can reference menus but not the menu items. Is this an issue with the version of Excel and a difference in VBA code? Or, am I off track somewhere? Thanks, Tommy ) |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Menu Items and Disable/Enable in Excel 2003
Hi
This worked for me in excel 2002. Application.CommandBars("Worksheet Menu Bar").Controls("&Tools").Controls("&Customize...") .Enabled = False HTH KenM |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How to enable items on Excel draw menu bar. | Excel Discussion (Misc queries) | |||
Excel 2003 format menu disable | Setting up and Configuration of Excel | |||
Can you enable/disable macro keyboard shortcuts in excel 2003? | Excel Discussion (Misc queries) | |||
Enable/Disable Drag and Drop in Excel 2003 via Registry | Excel Discussion (Misc queries) | |||
HELP - How do I disable Excels menu items so others can't use | Excel Programming |