hello.

I have this code for every workbook once it becomes the active workbook:
Private Sub Worksheet_Activate()
    
MsgBox ("Remember: Selecting 'Edit Sheet' will allow you to make changes.")
    
End Sub
Also, when I run macros that add to these sheets, I have the worksheet that it is added to activated.

Is there a way to only display that message box if the user is clicking between sheets but not when the macro is writing to the sheet?


Or to at least have the message pop up after the userform has been closed?

Thanks