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?
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

How do you evaluate cell value in vba 2
Setup Cells Without Looping 18
Enable / Disable Command Button depending on a cell's value 4
Sending mail to different mail address based on cell value 3
disable multiple toggle buttons 1
simple question "disable command buttons" 1
Referencing a Forms Button in a Worksheet 7
Disable/enable or lock/unlock cells in VBA dependent on other cells values 2

Back
Top