View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.misc
Sheeloo Sheeloo is offline
external usenet poster
 
Posts: 793
Default can you make excel open at the top instead of the bottom

It opens at the position it was last saved.

If you want it to go to A1 everytime you open the worksheet...
Right-click on the sheetname at the bottom, choose View Code and paste the
following;
Private Sub Worksheet_Activate()
Range("A1").Activate
End Sub

Close the editor


"Rebel" wrote:

I want excel to open at the top of my spreadsheet instead of the bottom