Always starting a workbook on a certain worksheet

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
 
R

Ron de Bruin

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
 
Top