hmm, sorry but I've tried this but have no idea. Went into the View Code on
the tab. copied your bit. Lets say I want them to go to sheet 1 cell a1.
How would I change what you've written.

"Mike" wrote:

Try this

Private Sub Workbook_Open()
Worksheets("Sheet1").Select '<-----Edit as required
Cells(1, 1).Select '<-----Edit as required
End Sub

Mike

"Gover" wrote:

When opening the workbook, I want the next person to open in a particular
cell in a certain sheet. Not where the last person saved the workbook. I
need to do something on the opening of the workbook, but cannot think. Please
help