Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
xlDialogActivate to Select Sheets?
Is it possible to call the Sheet Dialog box (I think xlDialogActivate) from VBA and allow the scrolling and selection of sheets? When I run Application.Dialogs(xlDialogActivate).Show it show "open" files, I wished it to show Tabs similar to when you right click on the "Tab Scroll Buttons"? Thanks |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
xlDialogActivate to Select Sheets?
From Jim Rech:
Sub aa() On Error Resume Next Err = 0 CommandBars("Workbook Tabs").Controls("More sheets...").Execute If Err < 0 Then CommandBars("Workbook Tabs").ShowPopup End Sub PDX wrote: Is it possible to call the Sheet Dialog box (I think xlDialogActivate) from VBA and allow the scrolling and selection of sheets? When I run Application.Dialogs(xlDialogActivate).Show it show "open" files, I wished it to show Tabs similar to when you right click on the "Tab Scroll Buttons"? Thanks -- Dave Peterson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Macro to select all sheets | Excel Discussion (Misc queries) | |||
how can i select all sheets in excell? | Excel Worksheet Functions | |||
USE KEYBOARD TO SELECT ALL SHEETS | Excel Worksheet Functions | |||
select a1 on all sheets | Excel Programming | |||
select sheets by name - how? | Excel Programming |