Set sheet viewpoint on workbook_open()

  • Thread starter Thread starter Robert Crandal
  • Start date Start date
R

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?
 
Include a line like this:

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