Thread
:
Index number for CommandBar right-click on sheet tab?
View Single Post
#
2
Posted to microsoft.public.excel.programming
Ardus Petus
external usenet poster
Posts: 718
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
Reply With Quote
Ardus Petus
View Public Profile
Find all posts by Ardus Petus