Cell A1 active cell upon opening

D

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?
 
F

Frank Kabel

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
 
J

Jim May

Enter into ThisWorkbook Module:

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