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
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
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" <[email protected]> wrote in message
news:[email protected]...
> 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
>
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" <[email protected]> wrote in message
>news:[email protected]...
>> 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
>>
>
>
>.
>
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks