How do I specify which worksheet I want activated in the Workbook_ope event? Thanks
B BananaQuaalude Jun 8, 2004 #1 How do I specify which worksheet I want activated in the Workbook_ope event? Thanks
K kkknie Jun 8, 2004 #2 Just use: Private Sub Workbook_Open() Application.ScreenUpdating = False 'Prevent screen flicker Sheets("Sheet1").Select Application.ScreenUpdating = True End Sub
Just use: Private Sub Workbook_Open() Application.ScreenUpdating = False 'Prevent screen flicker Sheets("Sheet1").Select Application.ScreenUpdating = True End Sub
P Pete McCosh Jun 8, 2004 #3 In the Workbook module, in the Open event: Sheets("My Sheet Name Here").Activate 'Cheers, Pete
