Thread
:
How do I set up an excel doc. to open on the same tab everytime
View Single Post
#
2
Posted to microsoft.public.excel.misc
Gord Dibben
Posts: n/a
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?
Reply With Quote