Open to Same Cell Each Time

  • Thread starter Thread starter jennie277
  • Start date Start date
J

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
 
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)
 
Back
Top