View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
David McRitchie
 
Posts: n/a
Default Keyboard shortcut to go to first worksheet in workbook?

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" wrote in message ...
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