View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
NickHK NickHK is offline
external usenet poster
 
Posts: 4,391
Default Set condition of button on click

Robb,
You've pretty much got it, in words, so in code:
Private Sub CommandButton1_Click()
CommandButton1.Enabled = False
End Sub

Private Sub CommandButton2_Click()
CommandButton1.Enabled = True
End Sub

NickHK

"Robb Quirk" wrote in message
...
Does anyone know how to use code or some other method to set the active

state
of a button once you click it? What I would like to happen is for Button1

to
be able to be clicked once, and then turn inactive (gray) until Button2 is
clicked. Any help would be appreciated.
Thanks in advance,
Robb