Open to Same Cell Each Time

[jennie277]

Hi

Is there anyway of getting a workbook to open up to the same cell or
worksheet each time, regardless of where it was saved when it was last
closed?

Thanks
Jennie

 

[Bob Phillips]

Jennie,

In the workbook open event add code to activate a worksheet and cell. As an
example

Private Sub Workbook_Open()
Worksheets("Sheet1").Activate
Range("A1").Select
End Sub


This code should be put in the ThisWorkbook code module, which is under the
Microsoft Excel Objects folder in the project pane.

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)