Customizing popup menus

[VanS]

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 P. Erlandsen]

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

[Bob Phillips]

see response in excel.misc

--

HTH

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


"VanS" <VanS@discussions.microsoft.com> wrote in message
news:6417EFD5-DDDD-4F50-85EF-00144DA194C2@microsoft.com...
> 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

[VanS]

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
>