| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Display "Activate" dialog from sheet navigation context menu
When you click the sheet navigation controls (bottom left) on a
worksheet, you get a list of the sheets in the workbook - if you have more sheets than will fit in the space allocated for this list, a dialog titled "Activate" appears. I have a workbook with 100+ sheets/ charts and would like to have a control that will display the "Activate" dialog. I've tried recording the actions, but all I get is the sheet selection I made. |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Display "Activate" dialog from sheet navigation context menu
Commandbars("Workbook Tabs").Show
Bob Umlas Excel MVP "ward376" wrote in message ups.com... When you click the sheet navigation controls (bottom left) on a worksheet, you get a list of the sheets in the workbook - if you have more sheets than will fit in the space allocated for this list, a dialog titled "Activate" appears. I have a workbook with 100+ sheets/ charts and would like to have a control that will display the "Activate" dialog. I've tried recording the actions, but all I get is the sheet selection I made. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| "Edit Query" back into context menu? | Excel Discussion (Misc queries) | |||
| Excel - Golf - how to display "-2" as "2 Under" or "4"as "+4" or "4 Over" in a calculation cell | Excel Discussion (Misc queries) | |||
| Prevent code in "Sheet Activate" from running when sheet made visible from other macr | Excel Programming | |||
| How to disable the "Insert Copied Cells" context menu item | Excel Programming | |||
| VBA code to display the "Find" (Ctrl+F) dialog box | Excel Programming | |||
Linear Mode
