Customizing popup menus
 

Hello,
I have an Excel/Word VBA app and I need to be able to customize the popup
(right click) menu on an Excel tab so I can add a custom command to insert my
own custom worksheet. I can only find ways to alter the regular menu bar, but
not the popup.
Can anyone tell me how to do so linked to an item to perform a macro or sub
routine. Is there a place to edit such menus or does it need to be done with
code, and if the latter, how?
Thanks, God bless
Van

Customizing popup menus
 

You can download a workbook example showing how to create or customize
popup (and other) menus in Excel from this page:
http://www.erlandsendata.no/english/...oadcommandbars

--
Ole P.

VanS wrote:
Hello,
I have an Excel/Word VBA app and I need to be able to customize the popup
(right click) menu on an Excel tab so I can add a custom command to insert my
own custom worksheet. I can only find ways to alter the regular menu bar, but
not the popup.
Can anyone tell me how to do so linked to an item to perform a macro or sub
routine. Is there a place to edit such menus or does it need to be done with
code, and if the latter, how?
Thanks, God bless
Van

Customizing popup menus
 

see response in excel.misc

--

HTH

RP
(remove nothere from the email address if mailing direct)


"VanS" wrote in message
...
Hello,
I have an Excel/Word VBA app and I need to be able to customize the popup
(right click) menu on an Excel tab so I can add a custom command to insert
my
own custom worksheet. I can only find ways to alter the regular menu bar,
but
not the popup.
Can anyone tell me how to do so linked to an item to perform a macro or
sub
routine. Is there a place to edit such menus or does it need to be done
with
code, and if the latter, how?
Thanks, God bless
Van

Customizing popup menus
 

Ole,
Thanks for your link-I will check it out.
From your name and URL I'm you must be from Norway. I still remember many
years ago as a university student going through Norway and appreciating the
great beauty of your country.
Thanks again, and God bless
Van

"Ole P. Erlandsen" wrote:

You can download a workbook example showing how to create or customize
popup (and other) menus in Excel from this page:
http://www.erlandsendata.no/english/...oadcommandbars

--
Ole P.

VanS wrote:
Hello,
I have an Excel/Word VBA app and I need to be able to customize the popup
(right click) menu on an Excel tab so I can add a custom command to insert my
own custom worksheet. I can only find ways to alter the regular menu bar, but
not the popup.
Can anyone tell me how to do so linked to an item to perform a macro or sub
routine. Is there a place to edit such menus or does it need to be done with
code, and if the latter, how?
Thanks, God bless
Van