Open to a particular cell in a particular worksheet

  • Thread starter Thread starter Larry
  • Start date Start date
L

Larry

I have a spreadsheet that had 10 worksheets. How would I
tell it to open to the 10th worksheet in a particular
cell. If I save it with my pointer in that cell, it still
opens to the first worksheet.
 
Hi Larry

Then you must have some code in the workbook Larry.
If you save a workbook with the activecell in Sheet3 it will open next time in Sheet3.

But you can use this in the Thisworkbook module to go to a specific sheet/cell

Private Sub Workbook_Open()
Application.Goto Reference:=Worksheets("Sheet10").Range("A100"), _
scroll:=True
End Sub
 
Back
Top