Home |
Search |
Today's Posts |
#1
|
|||
|
|||
How do I automatically open a spreadsheet in a specific worksheet?
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. |
#2
|
|||
|
|||
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 GT wrote: 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. -- Dave Peterson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How do I open an "excel spreadsheet file, extention .xls"? | Excel Discussion (Misc queries) | |||
Backup Spreadsheet while open | Excel Discussion (Misc queries) | |||
open workbook automatically | Excel Discussion (Misc queries) | |||
Why doesn't the spreadsheet file open. | Excel Discussion (Misc queries) | |||
How to open a spreadsheet with Macros disabled | Excel Discussion (Misc queries) |