Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Macro to launch the Activate dialog box?
I need to launch the Activate dialog box by using a keyboard shortcut. So I
want a macro that will do the launching, to which I'll assign a shortcut key. This is the dialog box that you get when you have move than 15 sheets in a workbook and you right-click on the sheet nagivation buttons to the left of the workbook's first sheet. The right-click displays a list of the workbook's first 15 sheets and a More Sheets... option. When you select the More Sheets option the Activate dialog box pops up, listing all worksheets in the workbook. From there you select the sheet you want to activate. I've tried this code line, but the dialog box shows open workBOOKS rather than workSHEETS. Application.Dialogs(xlDialogActivate).Show Can I do what I want to do without creating my own user form / dialog box or is this seemingly simple problem really a complex problem? Many thanks. |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Macro to launch the Activate dialog box?
Application.CommandBars("Workbook Tabs").ShowPopup
Ted M H wrote: I need to launch the Activate dialog box by using a keyboard shortcut. So I want a macro that will do the launching, to which I'll assign a shortcut key. This is the dialog box that you get when you have move than 15 sheets in a workbook and you right-click on the sheet nagivation buttons to the left of the workbook's first sheet. The right-click displays a list of the workbook's first 15 sheets and a More Sheets... option. When you select the More Sheets option the Activate dialog box pops up, listing all worksheets in the workbook. From there you select the sheet you want to activate. I've tried this code line, but the dialog box shows open workBOOKS rather than workSHEETS. Application.Dialogs(xlDialogActivate).Show Can I do what I want to do without creating my own user form / dialog box or is this seemingly simple problem really a complex problem? Many thanks. -- Dave Peterson |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Macro to launch the Activate dialog box?
Hi Dave,
Thanks a million. "Dave Peterson" wrote: Application.CommandBars("Workbook Tabs").ShowPopup Ted M H wrote: I need to launch the Activate dialog box by using a keyboard shortcut. So I want a macro that will do the launching, to which I'll assign a shortcut key. This is the dialog box that you get when you have move than 15 sheets in a workbook and you right-click on the sheet nagivation buttons to the left of the workbook's first sheet. The right-click displays a list of the workbook's first 15 sheets and a More Sheets... option. When you select the More Sheets option the Activate dialog box pops up, listing all worksheets in the workbook. From there you select the sheet you want to activate. I've tried this code line, but the dialog box shows open workBOOKS rather than workSHEETS. Application.Dialogs(xlDialogActivate).Show Can I do what I want to do without creating my own user form / dialog box or is this seemingly simple problem really a complex problem? Many thanks. -- Dave Peterson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Display "Activate" dialog from sheet navigation context menu | Excel Programming | |||
VBA - Launch VBA Macro From VB | Excel Programming | |||
Macro launch - Button vs Manual launch , has different results. | Excel Programming | |||
control of dialog macro dialog box. on open | Excel Programming | |||
Launch Macro in Access via Macro running in Excel??? | Excel Programming |