Open workbook to specific worksheet

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
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.
 
Thank you so much. Actually the worksheets are named 'Jan', 'Feb', etc., so
I simply changed what you wrote to 'mmm'. It works perfectly!
 
Lots of things changed, but not this stuff.

Did you allow macros to run?

Do you have a sheet that's named February?

Did you put the code in the ThisWorkbook module?
 
Back
Top