scotthannaford1973
Board Regular
- Joined
- Sep 27, 2017
- Messages
- 110
- Office Version
- 2010
- Platform
- Windows
Hi
I have a very basic message box that appears when someone goes to a particular worksheet; however I only want it to appear once, so if someone clicks onto another worksheet and then back to the one with the message box, it doesn't reappear. Would be grateful for assistance
Private Sub Worksheet_Activate()
msgbox "Do Not Sort This Worklist"
End Sub
I have a very basic message box that appears when someone goes to a particular worksheet; however I only want it to appear once, so if someone clicks onto another worksheet and then back to the one with the message box, it doesn't reappear. Would be grateful for assistance
Private Sub Worksheet_Activate()
msgbox "Do Not Sort This Worklist"
End Sub