• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 312
  • Last Modified:

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
0
cowboywm
Asked:
cowboywm
1 Solution
 
Michael FowlerSolutions ConsultantCommented:
Just set the enable property to false eg

Private Sub StartCommandButton_Click()
    ActiveCell.Offset(0, 3).Range("A1").Activate
    ActiveCell.Formula = Time
    StartCommandButton.Enabled = False
End Sub 

Open in new window


Michael
0
 
cowboywmAuthor Commented:
This did exactly what I wanted it to do.  Thanks, Michael.
0

Featured Post

Restore individual SQL databases with ease

Veeam Explorer for Microsoft SQL Server delivers an easy-to-use, wizard-driven interface for restoring your databases from a backup. No expert SQL background required. Web interface provides a complete view of all available SQL databases to simplify the recovery of lost database

Tackle projects and never again get stuck behind a technical roadblock.
Join Now