Keyboard shortcut to go to first worksheet in workbook?

[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

 

[David McRitchie]

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

 

[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

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

 

[Pete]

Don,

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

Pete