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

Index number for CommandBar right-click on sheet tab?
 

set cb = commandbars("Workbook tabs")


HTH
--
AP

"Shane in Canberra" a écrit dans
le message de news: ...
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

Index number for CommandBar right-click on sheet tab?
 

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" a écrit dans
le message de news: ...
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

Index number for CommandBar right-click on sheet tab?
 

Hi Shane,

Try Application.Commandbars("Ply")


---
Regards,
Norman



"Shane in Canberra" wrote in
message ...
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" a écrit
dans
le message de news: ...
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