How do I automatically open a spreadsheet in a specific worksheet?

G

GT

I have a main worksheet that I have hyperlinked all of the other worksheets.
It would be best if the user can always open this spreadsheet and go to this
main sheet right away.
 
D

Dave Peterson

If you save it with that worksheet selected, then it'll open that way.

Or you could use a macro (in a general module):

option explicit
sub auto_open()
application.goto thisworkbook.worksheets("Sheet99").range("a1"), _
scroll:=true
end sub

If you're new to macros, you may want to read David McRitchie's intro at:
http://www.mvps.org/dmcritchie/excel/getstarted.htm
 
Top