Set sheet viewpoint on workbook_open()
 

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?

Set sheet viewpoint on workbook_open()
 

Include a line like this:

Application.Goto Reference:=Worksheets("Sheet1").Range("A1"), scroll:=True
--
Gary''s Student - gsnu200909


"Robert Crandal" wrote:

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?


.