How can I open a worksheet to a specific cell?

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?
 
J

J.E. McGimpsey

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
 
Top