One-shot button

There are many ways of doing that, but all of them require that you modify the code the button calls.

1. Delete the button
2. Hide the button
3. Create a static variable to stop the code from running more than once.
   A Static variable retains its value between calls. So, if you set it to True whne you run the code for the first time it will still have that value when you try again. Here is a code snippet.
   
    

      Static Repeat As Boolean
   

       If Repeat Then
           MsgBox "You already performed this action"
       Else
           Repeat = True
           ' do your stuff here
       End If