Open specific worksheet on startup

[erisaaka]

What would be the macro to open a specific worksheet upon startup?

I am not very familiar with VBA so some instruction on where to paste the code would be helpful. Thank you.

[LJMetzger]

Hi erisaaika,

You will need to Access the 'ThisWorkbook' module. The following link should help you do that if you don't know how.
http://officetricks.com/excel-vba-for-beginners/

In 'ThisWorkbook' put the following code (e.g. if you want to open to 'Sheet2'):

Please Login or Register  to view this content.

Lewis

[erisaaka]

Worked perfectly, thank you!