Hi,

ALT+F11 to open vb editor. Doubleclick 'ThisWorkbook' and paste this in on
the right

Private Sub Workbook_Open()
Application.Goto Sheets("Sheet1").Range("A100"), True
End Sub

Mike

"Fan924" wrote:

On startup, I want it to show sheet1 and lets say row 100 instead of
whatever sheet it was on when I exited. TIA