No, it is not a formula. It has validation applied, to restrict person
from entering anything but certain values. The context is a design
project log that this macro would help notify certain people that a
design has been "flipped" to DONE.

(Value is "DONE")

Ron de Bruin wrote:
should clarify i need the email to be sent when ANY cells from a column
Are they all formulas

of cells changes to a certain value
What is the value ?

shared workbook
Always trouble


--
Regards Ron de Bruin
http://www.rondebruin.nl



"vincent" wrote in message oups.com...
Hi Ron

for a newbie like me, this is a little easier to follow. however, i
should clarify i need the email to be sent when ANY cells from a column
of cells changes to a certain value. this also should work from a
shared workbook...i have had problems with macros after you share the
workbook?

Vincent

On Nov 5, 3:38 am, "Ron de Bruin" wrote:
You can try this vincenthttp://www.rondebruin.nl/mail/change.htm

--
Regards Ron de Bruinhttp://www.rondebruin.nl



"vincent" wrote in oglegroups.com...
I have a shared workbook we use for internal
communication/collaboration.

Is there anyone that can generate vis basic code that would send an
email out automatically based on a cell changing to a certain value?
we use Outlook

e.g., if in a range of cells, a cell changes to a certain value, an
email would automatically be sent out to a certain list of people, with
a certain message text.- Hide quoted text -- Show quoted text -

Hi vincent

This will work for column A

Private Sub Worksheet_Change(ByVal Target As Range)
If Not Application.Intersect(Range("A:A"), Target) Is Nothing Then
If Target.Value = "DONE" Then
YourMacroName
End If
End If
End Sub

If it is possible use the CDO code
No security warnings then


--
Regards Ron de Bruin
http://www.rondebruin.nl



"vincent" wrote in message ups.com...
No, it is not a formula. It has validation applied, to restrict person
from entering anything but certain values. The context is a design
project log that this macro would help notify certain people that a
design has been "flipped" to DONE.

(Value is "DONE")

Ron de Bruin wrote:
should clarify i need the email to be sent when ANY cells from a column
Are they all formulas

of cells changes to a certain value
What is the value ?

shared workbook
Always trouble


--
Regards Ron de Bruin
http://www.rondebruin.nl



"vincent" wrote in message oups.com...
Hi Ron

for a newbie like me, this is a little easier to follow. however, i
should clarify i need the email to be sent when ANY cells from a column
of cells changes to a certain value. this also should work from a
shared workbook...i have had problems with macros after you share the
workbook?

Vincent

On Nov 5, 3:38 am, "Ron de Bruin" wrote:
You can try this vincenthttp://www.rondebruin.nl/mail/change.htm

--
Regards Ron de Bruinhttp://www.rondebruin.nl



"vincent" wrote in oglegroups.com...
I have a shared workbook we use for internal
communication/collaboration.

Is there anyone that can generate vis basic code that would send an
email out automatically based on a cell changing to a certain value?
we use Outlook

e.g., if in a range of cells, a cell changes to a certain value, an
email would automatically be sent out to a certain list of people, with
a certain message text.- Hide quoted text -- Show quoted text -