Hi everyone.
I am trying to add a menu item to another menu item.
Example: I have added a menu called "Product" to the Worksheet command bar between the "Window" and "Help" menus. Within this new "Product" menu I have added a menu item called "Export" by doing as follows:
Set Item = CommandBars(1).Controls("Product").Controls.Add
Item.Caption = "&Export"
Item.OnAction = "ExportMacro"
Now I want to add additional menu items so that they appear or becom availiable when the user moves the hovers the mouse cursor over the "Export" menu item. To see what I am wanting to do; in Excel go "File" then "Print View". When you hover the cursor over "Print View" it reveals several other menu item options. How do I do this?
Thanks
I am trying to add a menu item to another menu item.
Example: I have added a menu called "Product" to the Worksheet command bar between the "Window" and "Help" menus. Within this new "Product" menu I have added a menu item called "Export" by doing as follows:
Set Item = CommandBars(1).Controls("Product").Controls.Add
Item.Caption = "&Export"
Item.OnAction = "ExportMacro"
Now I want to add additional menu items so that they appear or becom availiable when the user moves the hovers the mouse cursor over the "Export" menu item. To see what I am wanting to do; in Excel go "File" then "Print View". When you hover the cursor over "Print View" it reveals several other menu item options. How do I do this?
Thanks