Always starting a workbook on a certain worksheet

[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

[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



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



"Tibbs" <Tibbs.2babop_1153467603.843@excelforum-nospam.com> wrote in message
news:Tibbs.2babop_1153467603.843@excelforum-nospam.com...
>
> 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
>

[Tibbs]

Brilliant! That worked...

Chris