Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
USE KEYBOARD TO SELECT ALL SHEETS
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. |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
USE KEYBOARD TO SELECT ALL SHEETS
In the macro use the Sheet Indexes to select:
Sheets(1) 'First Sheet Sheets(Sheets.Count) 'Last Sheet Charles enos newt gribble wrote: 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. |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
USE KEYBOARD TO SELECT ALL SHEETS
Faster to just use
activeworkbook.Worksheets.Select "Die_Another_Day" wrote: In the macro use the Sheet Indexes to select: Sheets(1) 'First Sheet Sheets(Sheets.Count) 'Last Sheet Charles enos newt gribble wrote: 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. |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
USE KEYBOARD TO SELECT ALL SHEETS
"Duke Carey" wrote: Faster to just use activeworkbook.Worksheets.Select "Die_Another_Day" wrote: In the macro use the Sheet Indexes to select: Sheets(1) 'First Sheet Sheets(Sheets.Count) 'Last Sheet Charles enos newt gribble wrote: 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. Worked Perfectly! Thanks |
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
USE KEYBOARD TO SELECT ALL SHEETS
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 wrote: 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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
keyboard shortcut to browse trough sheets | Excel Discussion (Misc queries) | |||
KEYBOARD SHORTCUT FOR SWAPING OF SHEETS | Excel Discussion (Misc queries) | |||
Macros-creating new sheets | Excel Worksheet Functions | |||
keyboard command used to select a range of nonadjacent cells? | Excel Discussion (Misc queries) | |||
keyboard command used to select a range of nonadjacent cells? | Excel Discussion (Misc queries) |