USE KEYBOARD TO SELECT ALL SHEETS

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

How can I use the key board to select all sheets. I have about 91 sheets
renamed and can't get MACRO to work well. I do change sheet names frequently
and don't want to edit a macro every time I do.
 
In the macro use the Sheet Indexes to select:
Sheets(1) 'First Sheet
Sheets(Sheets.Count) 'Last Sheet

Charles
 
In the macro use the Sheet Indexes to select:
Sheets(1) 'First Sheet
Sheets(Sheets.Count) 'Last Sheet

Charles
 
CTRL + Pageup until you get to first sheet.

CTRL + SHIFT + PageDown until all are selected.

If you hold all three keys down continuously you will quickly get to sheet91


Gord Dibben MS Excel MVP

On Tue, 22 Aug 2006 09:56:02 -0700, enos newt gribble <enos newt
 
CTRL + Pageup until you get to first sheet.

CTRL + SHIFT + PageDown until all are selected.

If you hold all three keys down continuously you will quickly get to sheet91


Gord Dibben MS Excel MVP

On Tue, 22 Aug 2006 09:56:02 -0700, enos newt gribble <enos newt
 
You must log in or register to reply here.

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

Collapsing all groups 0
Variable to rename a tab in a worksheet via VBA 5
macro to sum select columns in all workseets within a workbook 2
Macro to copy value in field and insert it into filter 2
cell reference 2
macro to sort is missing top row out??? 4
Sheet selected, automatic return to top of sheet 7
Macro help - Investor sheet 2

Back
Top