In VBA - Can any one explain how to - When opening workbook - use the current date (month) to goto the correct corresponding date named monthly worksheet (named January thru December)

JustLearningVB · Dec 5th 2019

Any help is greatly appreciated

**alansidman** · Dec 6th 2019

Put this in the Workbook Open Event

Code

Option Explicit

Private Sub Workbook_Open()
Dim ws As Worksheet
Dim sMonth As String, sDate As Date
sDate = Date
sMonth = MonthName(Month(sDate))
Sheets(sMonth).Activate
End Sub

JustLearningVB · Dec 6th 2019

Wow - thanks so much. You rock!

In VBA - Can any one explain how to - When opening workbook - use the current date (month) to goto the correct corresponding date named monthly worksheet (named January thru December)

Participate now!

Share

Tags