Open Excel ... Select WorkSheet

K

Ken

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
 
V

Vergel Adriano

Ken,

In the Thisworkbook code module:

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