Index number for CommandBar right-click on sheet tab?

I have some code that used to add some custom commands to the right-click
menu for the sheet tabs. We have moved to Excel2003 recently and now it
doesn't work any more.

Can someone please tell me what the index number is for the right-click menu
on the sheet tabs? It used to be 29 (ie
Application.CommandBars(29).Controls.Add).

Thanks in advance.
Shane in Canberra

set cb = commandbars("Workbook tabs")


HTH
--
AP

"Shane in Canberra" <[email protected]> a écrit dans
le message de news: [email protected]...
>I have some code that used to add some custom commands to the right-click
> menu for the sheet tabs. We have moved to Excel2003 recently and now it
> doesn't work any more.
>
> Can someone please tell me what the index number is for the right-click
> menu
> on the sheet tabs? It used to be 29 (ie
> Application.CommandBars(29).Controls.Add).
>
> Thanks in advance.
> Shane in Canberra

Thanks for that. I tried your suggestion, but it didn't work.

The index 29 is now the "cell" menu, so I can use it for now.

"Ardus Petus" wrote:

> set cb = commandbars("Workbook tabs")
>
>
> HTH
> --
> AP
>
> "Shane in Canberra" <[email protected]> a écrit dans
> le message de news: [email protected]...
> >I have some code that used to add some custom commands to the right-click
> > menu for the sheet tabs. We have moved to Excel2003 recently and now it
> > doesn't work any more.
> >
> > Can someone please tell me what the index number is for the right-click
> > menu
> > on the sheet tabs? It used to be 29 (ie
> > Application.CommandBars(29).Controls.Add).
> >
> > Thanks in advance.
> > Shane in Canberra
>
>
>

Hi Shane,

Try Application.Commandbars("Ply")


---
Regards,
Norman



"Shane in Canberra" <[email protected]> wrote in
message news:[email protected]...
> Thanks for that. I tried your suggestion, but it didn't work.
>
> The index 29 is now the "cell" menu, so I can use it for now.
>
> "Ardus Petus" wrote:
>
>> set cb = commandbars("Workbook tabs")
>>
>>
>> HTH
>> --
>> AP
>>
>> "Shane in Canberra" <[email protected]> a écrit
>> dans
>> le message de news: [email protected]...
>> >I have some code that used to add some custom commands to the
>> >right-click
>> > menu for the sheet tabs. We have moved to Excel2003 recently and now
>> > it
>> > doesn't work any more.
>> >
>> > Can someone please tell me what the index number is for the right-click
>> > menu
>> > on the sheet tabs? It used to be 29 (ie
>> > Application.CommandBars(29).Controls.Add).
>> >
>> > Thanks in advance.
>> > Shane in Canberra
>>
>>
>>