Make Excel default to certain worksheet on startup

Just wondering if there is a way to force excel to display a certain
worksheet upon opening a document regardless of which worksheet was
viewed last.

I have a document with about 75 different worksheets and have made a
"home sheet" that has links to all the others. I would like excel to
always go to this "home Sheet" when I first open the document.

Is there an easy way to set this?

Thanks


--
matpoh
------------------------------------------------------------------------
matpoh's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=27024
View this thread: http://www.excelforum.com/showthread.php?threadid=437631

dominicb
Tue Sep 06 11:39:24 CDT 2005


Good evening Matpoh

There is, but you are going to have to use macros to do so, but heres
what you do. Open your file in Excel with no other files open. Right
click on any tab and select View Code. In the sindow that opens double
click on ThisWorkbook (should be in the top lefthand pane). In the
blank window that opens copy this code:

Private Sub Workbook_Open()
Sheets("home Sheet").Select
End Sub

Close this window to return to Excel and save your file. Next time you
open the file it will open on your front sheet. However on opening the
file you will be asked if you want to run the macros. Obviously you
have to select yes.

HTH

DominicB


--
dominicb
------------------------------------------------------------------------
dominicb's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=18932
View this thread: http://www.excelforum.com/showthread.php?threadid=437631

matpoh
Tue Sep 06 12:21:58 CDT 2005


Yep, that worked like a charm.

Thanks


--
matpoh
------------------------------------------------------------------------
matpoh's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=27024
View this thread: http://www.excelforum.com/showthread.php?threadid=437631

dominicb
Tue Sep 06 12:40:59 CDT 2005


Hi Matpoh

You're welcome. Always appreciate feedback.

DominicB


--
dominicb
------------------------------------------------------------------------
dominicb's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=18932
View this thread: http://www.excelforum.com/showthread.php?threadid=437631