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?

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
[email protected]> 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?

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