Enable/Disable Button
 

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

--
Message posted from http://www.ExcelForum.com

Enable/Disable Button
 

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?

--
Regards,
Tom Ogilvy

surplusbc wrote in message
...
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?


---
Message posted from http://www.ExcelForum.com/