VBA Show Message On Sheet Activate

[Howardc]

I would like a message reminder to pop up with I select sheet "YTD"

The message should read "Remember to select the curent month period"

Your assistance in this regard is most appreciated

[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