Open a specific worksheet

[don]

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]

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]

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