Cell A1 active cell upon opening

[darkcity1965]

How do I make cell A1 the active cell upon opening a previously saved
file without having to ensure that it is the active cell when saving.

Are there any default settings or do I need to write a macro, if so
how?

 

[Guest]

Hi
you need VBA for this. e.g. put the following code in your workbook module
(not in a standard module):
sub workbook_open()
with me
application.goto reference:=.worksheets("sheet1").range("A1"), scroll:=true
end with
end sub

 

[Jim May]

Enter into ThisWorkbook Module:

Private Sub Workbook_Open()
Worksheets("sheet1").Activate ' change sheetname here if needed
Range("a1").Select
End Sub