Quote Originally Posted by xander1981 View Post
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