ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Load Sheet2 on Startup?? (https://www.excelbanter.com/excel-programming/307908-load-sheet2-startup.html)

Michael Vaughan

Load Sheet2 on Startup??
 
Hello Everyone,

I know I saw this somewhere, but for the life of me, I can't seem to find
it. I think somebody had a reference webpage to this. How do you set it
up, so that Sheet4 is displayed or initialized when I start my excel
program: airplane.xls????

Thanks.. mv



ForSale[_43_]

Load Sheet2 on Startup??
 
on airplane.xls, hit alt+F11, then go down to the ThisWorkbook page an
paste this:
Private Sub Workbook_Open()
Sheet4.Select
End Su

--
Message posted from http://www.ExcelForum.com


David Adamson[_4_]

Load Sheet2 on Startup??
 
Sub Auto_Open()
Worksheets("Name").Activate
End sub


"Michael Vaughan" wrote in message
...
Hello Everyone,

I know I saw this somewhere, but for the life of me, I can't seem to find
it. I think somebody had a reference webpage to this. How do you set it
up, so that Sheet4 is displayed or initialized when I start my excel
program: airplane.xls????

Thanks.. mv






All times are GMT +1. The time now is 09:58 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com