VBA Show Message On Sheet Activate

[xander1981]

Remember to select code for the YTd Sheet, Select 'Worksheet' from the drop down menu and select 'Activate' from the next drop down menu next to it.

Private Sub Worksheet_Activate()
MsgBox ("Remember to select the curent month period")
End Sub

[Howardc]

Remember to select code for the YTd Sheet, Select 'Worksheet' from the drop down menu and select 'Activate' from the next drop down menu next to it.

Private Sub Worksheet_Activate()
MsgBox ("Remember to select the curent month period")
End Sub

Thanks for the help, much appreciated