Always starting a workbook on a certain worksheet
 

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


--
Tibbs
------------------------------------------------------------------------
Tibbs's Profile: http://www.excelforum.com/member.php...o&userid=15947
View this thread: http://www.excelforum.com/showthread...hreadid=563584

Always starting a workbook on a certain worksheet
 

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



--
Regards Ron de Bruin
http://www.rondebruin.nl



"Tibbs" wrote in message
...

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


--
Tibbs
------------------------------------------------------------------------
Tibbs's Profile: http://www.excelforum.com/member.php...o&userid=15947
View this thread: http://www.excelforum.com/showthread...hreadid=563584

Always starting a workbook on a certain worksheet
 

Brilliant! That worked...

Chris


--
Tibbs
------------------------------------------------------------------------
Tibbs's Profile: http://www.excelforum.com/member.php...o&userid=15947
View this thread: http://www.excelforum.com/showthread...hreadid=563584