show sheet1 on startup

F

Fan924

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

Mike H

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
 
D

Dave Peterson

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
 
M

mdmackillop

Paste this into ThisWorkbook module
Private Sub Workbook_Open()
Sheets(1).Activate
ActiveWindow.ScrollRow = 100
ActiveWindow.ScrollColumn = 1
End Su
 
Top