William C Johnson
asked on
Disable a Command Button
I have a command button called StartCommandButton. When it is clicked it runs the following procedure. I want the button disabled when it completes the click event procedure. Users may only click it one time.
Private Sub StartCommandButton_Click()
ActiveCell.Offset(0, 3).Range("A1").Activate
ActiveCell.Formula = Time
End Sub
Private Sub StartCommandButton_Click()
ActiveCell.Offset(0, 3).Range("A1").Activate
ActiveCell.Formula = Time
End Sub
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER