Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Enabling sub menu items via vba
I'm using an activeX container to embed an excel document into my app. It
has several menu items I need to use disabled though. Since I don't want to try and figure out how the ~400k of c++ source works to fix the problem I'm trying to do it in vba. The problem is with the change tracking menu item group. I can enable the main item on the tools menu, but not the subitems that popup when it's selected. I can't figure out how to access the subitems to enable them. The code below includes how I've enabled the track changes item as well as 3 unsucessful attempts to enable the Highlight CHanges subitem. Sub EnableTracking() 'This works but doesn't affect it's children Application.CommandBars("Tools").Controls("Track Changes").Enabled = True 'this generates an runtime error Application.CommandBars("Tools").Controls("Highlig ht Changes...").Enabled = True 'As does this. Application.CommandBars("Track Changes").Controls("Highlight Changes...").Enabled = True 'This doesn't generate an error but doesn't work either. Application.CommandBars("Tools").Controls("Track Changes").Controls("Highlight Changes...").Enabled = True End Sub activeX container location http://support.microsoft.com/default...b;en-us;311765 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Drop down menu | Excel Worksheet Functions | |||
Enabling shortcut menu | Excel Discussion (Misc queries) | |||
How do I change the highlight color of selected menu items? | Excel Discussion (Misc queries) | |||
menu items grayed out. | Excel Discussion (Misc queries) | |||
Menu items added with menu item editor in older versions | Excel Discussion (Misc queries) |