Open Month Tab based on current month

[mikeannetta]

I wish to have the ability to open a workbook based on current month. Whether is macro after I open the Workbook, or a something I can put in the VBA Project "This Worksheet"?
I have the TABS Named ( January, February, March ...) along with other names including, Dash Board, Up to Date. So when I open the file on February 15, it will open the file directly to the Tab named "February"

Thanks for the help from the group!

 

[DanteAmor]

Put the following in thisworkbook events

Private Sub Workbook_Open()
  Dim m As String
  m = Format(Date, "mmmm")
  On Error Resume Next
  Sheets(m).Select
End Sub

- Open the VB Editor (press Alt + F11).
- Over in the Project Explorer, double click on ThisWorkbook.
- In the white panel that then appears, paste the above code.

 

[mikeannetta]

Private Sub Workbook_Open() Dim m As String m = Format(Date, "mmmm") On Error Resume Next Sheets(m).Select End Sub

Perfect and quick response! I can thank you enough!