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

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

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



.