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