Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
PopUp menu for sheet and chart
Hi!
How simple to create menu: Application.CommandBars.Controls...msoControlPopup .. with some subs, for worksheets and chart too? I create menu but it's hide when i select sheets("chart"). Regards Mark |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
PopUp menu for sheet and chart
Mark,
On an Excel sheet the menu bar show is 'Worksheet Menu Bar'. On a chart it is 'Chart Menu Bar'. So you have to add your menu to the 'Chart Menu Bar' commandbar (as well as Worksheet Menu Bar?). -- HTH RP (remove nothere from the email address if mailing direct) "Mark" wrote in message ... Hi! How simple to create menu: Application.CommandBars.Controls...msoControlPopup .. with some subs, for worksheets and chart too? I create menu but it's hide when i select sheets("chart"). Regards Mark |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
PopUp menu for sheet and chart
Thanks Bob for your help!
Now, menu work satisfactorily. Best Regards Mark -----Original Message----- Mark, On an Excel sheet the menu bar show is 'Worksheet Menu Bar'. On a chart it is 'Chart Menu Bar'. So you have to add your menu to the 'Chart Menu Bar' commandbar (as well as Worksheet Menu Bar?). -- HTH RP (remove nothere from the email address if mailing direct) "Mark" wrote in message ... Hi! How simple to create menu: Application.CommandBars.Controls...msoControlPopup .. with some subs, for worksheets and chart too? I create menu but it's hide when i select sheets ("chart"). Regards Mark . |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Popup Menu / Shortcut Menu | Excel Discussion (Misc queries) | |||
Disable popup menu | Excel Programming | |||
Adding to Chart Popup menu | Excel Programming | |||
Popup Menu | Excel Programming | |||
add combo box at popup menu | Excel Programming |