Keyboard shortcut to go to first worksheet in workbook?

D

Don S

Is there a keyboard shortcut that will go to the first worksheet in a
workbook? I can use the mouse to click on the double arrow left, but
some activities aren't as efficient when my hands are on the keyboard.

I use the first worksheet as an index listing all the worksheets in
the workbook with hyperlinks to them. It works well to keep up with
update progress.

Thanks!

Don S
 
D

Don S

Hi Don,
You would have to make your own shortcut
http://www.mvps.org/dmcritchie/excel/install.htm

Sub GoToFirstSheet()
'David McRitchie, 2006-01-27
On Error Resume Next
Sheets(1).Select
End Sub

More GoToStuff (goes with various web pages)
http://www.mvps.org/dmcritchie/excel/code/gotostuff.txt
---
HTH,
David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001]
My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm
Search Page: http://www.mvps.org/dmcritchie/excel/search.htm

Don S said:
Is there a keyboard shortcut that will go to the first worksheet in a
workbook? I can use the mouse to click on the double arrow left, but
some activities aren't as efficient when my hands are on the keyboard.

I use the first worksheet as an index listing all the worksheets in
the workbook with hyperlinks to them. It works well to keep up with
update progress.

Thanks!

Don S
Click to expand...
Click to expand...

Thanks David,

...also for the "go to the right of the current row". I've needed the
opposite of "Home" in this same monthly update.

Don S
 
P

Pete

Don,

you could have a hyperlink in every sheet which points back to your
index sheet.

Pete
 
Top