lol it occurred right before I read it that the macros were disabled!!
You all ROCK...thanks sooooo much!

"Sheeloo" wrote:

Ok.

btw macros must be enabled for the code to work.

"Rebel" wrote:

Nope.....not working...I will just tell her to save it at the top.

"Sheeloo" wrote:

Download http://wikisend.com/download/589412/GoTo A1.xls
and compare with what you are doing..

To test
select any cell in sheet1...
go to sheet2 or sheet3
click on sheet1 to come back to it
It should open at A1

"Rebel" wrote:

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