show sheet1 on startup
On startup, I want it to show sheet1 and lets say row 100 instead of
whatever sheet it was on when I exited. TIA |
show sheet1 on startup
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 |
show sheet1 on startup
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 |
show sheet1 on startup
Paste this into ThisWorkbook module Private Sub Workbook_Open() Sheets(1).Activate ActiveWindow.ScrollRow = 100 ActiveWindow.ScrollColumn = 1 End Sub -- mdmackillop ------------------------------------------------------------------------ mdmackillop's Profile: http://www.thecodecage.com/forumz/member.php?userid=113 View this thread: http://www.thecodecage.com/forumz/sh...ad.php?t=69237 |
show sheet1 on startup
Thanks
|
All times are GMT +1. The time now is 10:48 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com