Best to do it workbook open

Private Sub Workbook_Open()
Worksheets(1).Activate
End Sub

put this in the ThisWorkbook code module.

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)

"mhillis " wrote in message
...
Is there a way of making an excel file revert to the first page each
time the file is closed. If possible is it something that can be put in
this thread (text) so I can copy and past it into note pad and then be
able to use it? I am unable to download off the internet on this
computer.
Yhanks in advance for any help anyone can give.


---
Message posted from http://www.ExcelForum.com/