Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
How do I set up an excel doc. to open on the same tab everytime
i'm using excel 2003. I need to set up a doument that has lots of tabs, one
of them being a "directory" tab with hyperlinks to tabs within this document. I would like my document to always open on the "directory" tab, regardless of who/where it was saved last. This document is used by many people so we do not want to set up a macro. Can this be done? |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
How do I set up an excel doc. to open on the same tab everytime
Dana
Not without using VBA code(macro). Private Sub Workbook_Open() Sheets("directory").Activate End Sub Gord Dibben Excel MVP On Thu, 17 Nov 2005 11:11:03 -0800, "Dana Stricker" <Dana wrote: i'm using excel 2003. I need to set up a doument that has lots of tabs, one of them being a "directory" tab with hyperlinks to tabs within this document. I would like my document to always open on the "directory" tab, regardless of who/where it was saved last. This document is used by many people so we do not want to set up a macro. Can this be done? |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
How do I set up an excel doc. to open on the same tab everytime
As long as everyone saves it in the correct location, it'll open ok.
But you'll need a macro if you can't trust them all to do this: Option Explicit sub auto_open() application.goto worksheets("directory").range("a1"),scroll:=true end sub (if you change your mind.) Dana Stricker wrote: i'm using excel 2003. I need to set up a doument that has lots of tabs, one of them being a "directory" tab with hyperlinks to tabs within this document. I would like my document to always open on the "directory" tab, regardless of who/where it was saved last. This document is used by many people so we do not want to set up a macro. Can this be done? -- Dave Peterson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
CSV formatted files open odly in Excel 2000 | Excel Discussion (Misc queries) | |||
why does excel 2002 add a '1' to the filename everytime I open a f | Excel Discussion (Misc queries) | |||
Open an existing excel speadsheet, opens Excel but not the file?? | Excel Discussion (Misc queries) | |||
How do i open excel doc in works? | Excel Discussion (Misc queries) | |||
External Links on open and Excel 2003 | Excel Discussion (Misc queries) |