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

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

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

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