Open a specific worksheet

Hi,

Just reading some of the other posts I am drawn to ask a follow up
question. I have a workbook with sheets named for each month of the year.

Is it possible to have the opening sheet open on the month of the year..
so jan is the opening sheet during January and February the opening
sheet in february etc etc.

Regards

Don

Option Explicit

Private Sub Workbook_Open()
Worksheets(Format(Date, "mmmm")).Activate
End Sub

'This is workbook event code.
'To input this code, right click on the Excel icon on the worksheet
'(or next to the File menu if you maximise your workbooks),
'select View Code from the menu, and paste the code

--

HTH

RP
(remove nothere from the email address if mailing direct)


"don" <don.hart1@ntlworld.com> wrote in message
news:TYBhf.4909$a15.852@newsfe5-win.ntli.net...
> Hi,
>
> Just reading some of the other posts I am drawn to ask a follow up
> question. I have a workbook with sheets named for each month of the year.
>
> Is it possible to have the opening sheet open on the month of the year..
> so jan is the opening sheet during January and February the opening
> sheet in february etc etc.
>
> Regards
>
> Don

Bob Phillips wrote:
> Option Explicit
>
> Private Sub Workbook_Open()
> Worksheets(Format(Date, "mmmm")).Activate
> End Sub
>
> 'This is workbook event code.
> 'To input this code, right click on the Excel icon on the worksheet
> '(or next to the File menu if you maximise your workbooks),
> 'select View Code from the menu, and paste the code
>
many thanks bob thats fantastic

regards

don