Open Excel ... Select WorkSheet
 

Excel2003 ... I previously submitted a 2 question post ... However, only 1
question answered ... That said ... I am back.

I have 12 WorkSheets ... Jan, Feb Mar etc ...

When I open my WorkBook ... I wish for the current Month WorkSheet to be
selected.

I am assuming I need a little Code from the Code writers ... Thanks ... Kha

Open Excel ... Select WorkSheet
 

Ken,

In the Thisworkbook code module:

Private Sub Workbook_Open()
ThisWorkbook.Sheets(Format(Date, "mmm")).Activate
End Sub



--
Hope that helps.

Vergel Adriano


"Ken" wrote:

Excel2003 ... I previously submitted a 2 question post ... However, only 1
question answered ... That said ... I am back.

I have 12 WorkSheets ... Jan, Feb Mar etc ...

When I open my WorkBook ... I wish for the current Month WorkSheet to be
selected.

I am assuming I need a little Code from the Code writers ... Thanks ... Kha