View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Ron de Bruin Ron de Bruin is offline
external usenet poster
 
Posts: 11,123
Default 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