software

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

Hi Don,
You would have to make your own shortcut
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)
www.mvps.org/dmcritchie/excel/code/gotostuff.txt
---
HTH,
David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001]
My Excel Pages: www.mvps.org/dmcritchie/excel/excel.htm
Search Page: www.mvps.org/dmcritchie/excel/search.htm

quot;Don Squot; gt; wrote in message ...
gt; Is there a keyboard shortcut that will go to the first worksheet in a
gt; workbook? I can use the mouse to click on the double arrow left, but
gt; some activities aren't as efficient when my hands are on the keyboard.
gt;
gt; I use the first worksheet as an index listing all the worksheets in
gt; the workbook with hyperlinks to them. It works well to keep up with
gt; update progress.
gt;
gt; Thanks!
gt;
gt; Don S
On Fri, 27 Jan 2006 13:26:55 -0500, quot;David McRitchiequot;
gt; wrote:

gt;Hi Don,
gt;You would have to make your own shortcut
gt; www.mvps.org/dmcritchie/excel/install.htm
gt;
gt;Sub GoToFirstSheet()
gt;'David McRitchie, 2006-01-27
gt; On Error Resume Next
gt; Sheets(1).Select
gt;End Sub
gt;
gt;More GoToStuff (goes with various web pages)
gt; www.mvps.org/dmcritchie/excel/code/gotostuff.txt
gt;---
gt;HTH,
gt;David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001]
gt;My Excel Pages: www.mvps.org/dmcritchie/excel/excel.htm
gt;Search Page: www.mvps.org/dmcritchie/excel/search.htm
gt;
gt;quot;Don Squot; gt; wrote in message ...
gt;gt; Is there a keyboard shortcut that will go to the first worksheet in a
gt;gt; workbook? I can use the mouse to click on the double arrow left, but
gt;gt; some activities aren't as efficient when my hands are on the keyboard.
gt;gt;
gt;gt; I use the first worksheet as an index listing all the worksheets in
gt;gt; the workbook with hyperlinks to them. It works well to keep up with
gt;gt; update progress.
gt;gt;
gt;gt; Thanks!
gt;gt;
gt;gt; Don S
gt;

Thanks David,

...also for the quot;go to the right of the current rowquot;. I've needed the
opposite of quot;Homequot; in this same monthly update.

Don S
Don,

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

Pete