| Home |
| Search |
| Today's Posts |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How can I click on a telephone number in an Excel 2002 spreadsheet, and have the number dialed? | Excel Discussion (Misc queries) | |||
| dragging the row contents of all the sheet to a Index sheet | Excel Discussion (Misc queries) | |||
| maximum number of Right-click options | Excel Programming | |||
| event with commandbar button right-click? | Excel Programming | |||
| Before right click in a sheet | Excel Programming | |||
Threaded Mode
