Display "Activate" dialog from sheet navigation context menu

W

ward376

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Macro to launch the Activate dialog box? 2
Sheet activate question 4
Sheet navigation, if there isn't hotkey for "go to first sheet"? 5
Activate Sheet 5
Error Message - Macro to Unlink MS Queries from Workbook 0
Select Sheets to Print 11
Unhide sheet, copy and rename new sheets from list, rehide sheet 8
Selecting worksheet and ranges within sheet to run macro on 3

Top