Set sheet viewpoint on workbook_open()

[Robert Crandal]

When Workbook_Open() is called, I want to tell Excel to
begin the viewpoint in the top left corner, starting at cell "A1".

A user will sometimes save their workbook while viewing
cells far below, such as "J200". When they re-open the
workbook, the workbook with open at cell "J200", but
I would rather have the sheet open at cell "A1". How do
I do this?

 

[Gary''s Student]

Include a line like this:

Application.Goto Reference:=Worksheets("Sheet1").Range("A1"), scroll:=True