I inherited an Excel macro which adds a customized item (with dropdowns) to the menu bar. I can't figure out how to delete any of the submenu items. It can't be done from Excel's menu customization function, yet when i go into the arear of the macro where the menubars are controlled, there's no effect if I rem them out or delete them. They still appear! Here's an example:
Sub Menu_Control(EnableBool)
MenuBars(xlWorksheet).Menus("Price Estimate". _
MenuItems("Add Item To Main Estimate".Enabled = EnableBool
MenuBars(xlWorksheet).Menus("Price Estimate". _
MenuItems("Add Item To Options".Enabled = EnableBool
Dos anyone have any ideas?
Thanks!
Sub Menu_Control(EnableBool)
MenuBars(xlWorksheet).Menus("Price Estimate". _
MenuItems("Add Item To Main Estimate".Enabled = EnableBool
MenuBars(xlWorksheet).Menus("Price Estimate". _
MenuItems("Add Item To Options".Enabled = EnableBool
Dos anyone have any ideas?
Thanks!