Startup defaul sheet in a workbook

[GeoN]

Does anyone know how to make a workbook open in the same
or default sheet every time is opened?

I have a workbook with 15 sheets. How can I make excel to
open it in the first sheet everytime I open this
workbook?....

Excel always remembers the last active sheet that the
workbook had open at the time it was save and close..

Anybody has any suggestions?

Thank you in advance

 

[Paul B]

GeoN, you could use a macro to do it, like this, put in thisworkbook code

Private Sub Workbook_Open()
Sheets("Sheet1").Select
End Sub

--
Paul B
Always backup your data before trying something new
Please post any response to the newsgroups so others can benefit from it
Feedback on answers is always appreciated!
Using Excel 97 & 2000
** remove news from my email address to reply by email **