View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Ardus Petus Ardus Petus is offline
external usenet poster
 
Posts: 718
Default 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