How can I open a worksheet to a specific cell?

  • Thread starter Thread starter kelly143
  • Start date Start date
K

kelly143

I have a public worksheet and people update as needed and just hit save,
and the next user opens to the cell where it was last saved. How can I
have the wooksheet save in any cell, and open in A1 the next time it is
accessed?
 
One way:

Put this in the ThisWorkbook code module (right-click on the
workbook title bar, choose View Code, paste the following in the
window that opens, then click the XL icon on the toolbar to return
to XL)

Private Sub Workbook_Open()
Application.Goto Worksheets("Sheet1").Range("A1")
End Sub
 
Back
Top