Enable/Disable Button

  • Thread starter Thread starter surplusbc
  • Start date Start date
S

surplusbc

Hi All,

I have a button with the code...

Private Sub Send_Click()
Send.Enabled = False
ActiveWorkbook.SendMail "MYEMAIL ADDRESS", _
"Request"
End Sub

So, after one click, the button gets disabled and an e-mail is sent
What I would like to do is, if any of the following Cells, A1-A3 & C1
C3 are changed, the button is enabled again. Any ideas
 
What causes the values in the cells to change. Are they manually edited.
Is it done with formulas and a recalc? Are they links to a DDE source?
what version of Excel?
 
Back
Top