VBA Show Message On Sheet Activate

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

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.

Code:

---

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

---

Quote:

---

Originally Posted by 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.

Code:

---

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

---

---

Thanks for the help, much appreciated