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/

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/

You can use this event for this

Private Sub Workbook_BeforeClose(Cancel As Boolean)
Sheets(1).Select
End Sub

Right click on the Excel icon next to File in the menubar
And choose View code

You are now in the Thisworkbook module
Paste the Event in this place
Alt-Q to go back to Excel
Save the file


--
Regards Ron de Bruin
(Win XP Pro SP-1 XL2000-2003)
www.rondebruin.nl



"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/

now is there anyway to get the first page to be the page opened when the
file is opened, now matter what page the file was saved on?


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

Hi

now is there anyway to get the first page to be the page opened when the
file is opened, now matter what page the file was saved on?


If you save the file one time with Sheet1 active then
this event is doing this if you not use the save button.
If you close the file with the X or FileClose this is working

But you can use this to select sheet1 when you open the workbook

Private Sub Workbook_Open()
Sheets(1).Select
End Sub

--
Regards Ron de Bruin
(Win XP Pro SP-1 XL2000-2003)
www.rondebruin.nl



"mhillis " wrote in message ...
now is there anyway to get the first page to be the page opened when the
file is opened, now matter what page the file was saved on?


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

I've already given you that!

--

HTH

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

"mhillis " wrote in message
...
now is there anyway to get the first page to be the page opened when the
file is opened, now matter what page the file was saved on?


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