You can use a macro (assuming that users will allow macros to run).

This goes in a General module--not behind ThisWorkbook and not behind a
worksheet.

Option Explicit
Sub Auto_Open()

application.goto thisworkbook.worksheets("Sheet1").range("a100"), _
scroll:=true

End sub

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

--

Dave Peterson