Hello. I am trying to run a macro upon the selection of a chart sheet. I can successfully run a macro upon selection of a worksheet by putting the following code on the worksheet module:
Private Sub Worksheet_Activate()
MsgBox "WARNING: To paste your data, please use the PASTE MY DATA...