Neither code is working....

"Sheeloo" wrote:

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