Set Active Worksheet onOpen
 

How do I specify which worksheet I want activated in the Workbook_ope
event?

Thanks

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

Set Active Worksheet onOpen
 

Just use:

Private Sub Workbook_Open()

Application.ScreenUpdating = False 'Prevent screen flicker
Sheets("Sheet1").Select
Application.ScreenUpdating = True

End Sub



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

Set Active Worksheet onOpen
 

In the Workbook module, in the Open event:

Sheets("My Sheet Name Here").Activate

'Cheers, Pete

-----Original Message-----
How do I specify which worksheet I want activated in the
Workbook_open
event?

Thanks!


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

.

Set Active Worksheet onOpen
 

Awesome- thank you both

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