View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.programming
Ron de Bruin Ron de Bruin is offline
external usenet poster
 
Posts: 11,123
Default reverting to first page on exit

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/