PopUp menu for sheet and chart

[Mark]

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

 

[Bob Phillips]

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]

Thanks Bob for your help!
Now, menu work satisfactorily.
Best Regards
Mark