This isn't working for me in Excel 2007. Did something change?

"Smallweed" wrote:

Put the following into the ThisWorkbook module:

Private Sub Workbook_Open()
Sheets(Format(Now, "mmmm")).Activate
End Sub

I'm assuming you've called the sheets January, February etc.

"mathel" wrote:

I think there is an easy solution to this, but I can't find it.

I have a workbook divided into 12 worksheets, one for each month. On
opening the workbook, I would like it to open at the worksheet for the
current month.

Can anyone help with a code for this?

Thanks
--
Linda