Set Active Worksheet onOpen

  • Thread starter Thread starter BananaQuaalude
  • Start date Start date
B

BananaQuaalude

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

Thanks
 
Just use:

Private Sub Workbook_Open()

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

End Sub
 
In the Workbook module, in the Open event:

Sheets("My Sheet Name Here").Activate

'Cheers, Pete
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Application Level Events Question 3
Email and if statements 1
trigger worksheet activate event in another worksheet 2
Rookie Question - Activating Worksheets 2
the default worksheet 3
Working with Excel 2003 from a Visual C++ program 1
Excel crashes and restarts when accessing newly created worksheet 2
If Worksheet Active, Go To Cell A1 1

Back
Top