Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
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 ) |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
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 |