LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 6
Default Sheet navigation, if there isn't hotkey for "go to first sheet"?

I know that there is Ctrl+PageUp + Ctrl+PageDown to navigation/browse
back and forth in a workbook but couldn't find anything via google re
a hotkey to go to first and last sheets. If there isn't anything,
thought that a macro would do.

If no hotkey, thought that something like this might work:

Sub GOto_First_Sheet_in_Workbook()
Sheets("Worksheets(1)").Activate
End Sub

But I don't know how to type in the generic name for the first sheet.
I believe I've used Worksheets(1) in other cases but this isn't
working here and I can't find what to do to go to the last sheet, also
using a generic term rather than a specific sheet name. This way I
can put this into my PERSONAL.xls.

Thanks! :oD
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
find "Cancellation" in column "A" and copy all data from Columns B-F onto another Sheet bjohnson Excel Programming 1 September 20th 07 04:02 PM
Display "Activate" dialog from sheet navigation context menu ward376 Excel Programming 1 April 5th 07 10:47 PM
Change default in input box from "20" to "000000"? Have macro continue on to name sheet tab? StargateFanFromWork[_4_] Excel Programming 7 October 29th 06 11:46 AM
Prevent code in "Sheet Activate" from running when sheet made visible from other macr Simon Lloyd[_794_] Excel Programming 10 June 21st 06 09:15 AM
Please add a "sheet" function like "row" and "column" functions Spreadsheet Monkey Excel Programming 2 November 8th 05 04:08 PM


All times are GMT +1. The time now is 07:03 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"