How to disable a Form Control Burron once Clicked?

I am wondering if I can disable a Form Control Button (Running a Macro), once a user clicks on the button. Here's the Macro:

Sub Macro7()
'
' Macro7 Macro
'

'
Application.Goto Reference:="R80C8"
Range("H80").Select
ActiveCell.FormulaR1C1 = "=username()&TEXT(NOW(),""0000000000.00000"")*100000"
Application.Goto Reference:="R80C8"
Range("h80").Select
Selection.Copy
Application.Goto Reference:="R80C12"
Range("l80").Select
Selection.PasteSpecial Paste:=xlPasteValues, Operation:=xlNone, SkipBlanks:=False, Transpose:=False
Application.Goto Reference:="R80C8"
Range("h80").Select
Selection.ClearContents


End Sub


Thank you!

Try something like :-

Please Login or Register  to view this content.

Thank you!