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