View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Gord Dibben
 
Posts: n/a
Default 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?