How do I set up an excel doc. to open on the same tab everytime

[Guest]

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?

 

[Gord Dibben]

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

 

[Dave Peterson]

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.)