Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

MenuBars in Excel VB macro

Status
Not open for further replies.

LCPump

Technical User
Feb 21, 2002
5
US
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!
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top