Always starting a workbook on a certain worksheet

  • Thread starter Thread starter Tibbs
  • Start date Start date
T

Tibbs

I create spreadsheets that get sent out to the business, and I'm very
bad at remembering to reset the sheet to the starting sheet.

How do I set the workbook up so it always opens on a particular
worksheet?

Is it easy?

Many thanks,

Chris
 
Hi Tibbs

You can use the open event of the workbook to select the sheet you want

Copy this in the thisworkbook module

Private Sub Workbook_Open()
Sheets("YourSheet").Select
End Sub
 

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

Merge Multiple workbook sheets into one workbook 0
Excel Move or Copy Stopped Working? 0
How to extract email addresses from 1 worksheet to another workbook 11
Forcing a workbook to open on a certain page 6
Code to format cells on several worksheets 2
Excel shortcut options 0
Link one worksheet in a workbook to another worksheet in same work 1
Certain worksheets won't print 1

Back
Top