How to write a macro so that if a value in a cell is exceeded, the excel
window will flash or turn to red?

In a financial excel spread sheet, a manager has to keep track on the total
money
every day. If the money is exceed a certain value he has to take actions.

How to make this automation by flashing or turn red or even better send
email?

Thanks
Daniel

Ron de Bruin is pretty much the master of this stuff!!
http://www.rondebruin.nl/mail/change.htm

Oh, and this is worth a look too:
http://www.contextmagic.com/express-clickyes/
I don't think you will be sending multiple emails, but if you do, run that
small utility. Try sending multiple emails without it, and try sending
multiple emails with it...it's magic....

Regards,
Ryan---

--
RyGuy


"Daniel" wrote:

>
> How to write a macro so that if a value in a cell is exceeded, the excel
> window will flash or turn to red?
>
> In a financial excel spread sheet, a manager has to keep track on the total
> money
> every day. If the money is exceed a certain value he has to take actions.
>
> How to make this automation by flashing or turn red or even better send
> email?
>
> Thanks
> Daniel
>
>

Or use Outlook 2007 or CDO or redemption

See
http://www.rondebruin.nl/mail/prevent.htm


--

Regards Ron de Bruin
http://www.rondebruin.nl/tips.htm


"ryguy7272" <(E-Mail Removed)> wrote in message news:CF928B43-57FD-4A59-BE88-(E-Mail Removed)...
> Ron de Bruin is pretty much the master of this stuff!!
> http://www.rondebruin.nl/mail/change.htm
>
> Oh, and this is worth a look too:
> http://www.contextmagic.com/express-clickyes/
> I don't think you will be sending multiple emails, but if you do, run that
> small utility. Try sending multiple emails without it, and try sending
> multiple emails with it...it's magic....
>
> Regards,
> Ryan---
>
> --
> RyGuy
>
>
> "Daniel" wrote:
>
>>
>> How to write a macro so that if a value in a cell is exceeded, the excel
>> window will flash or turn to red?
>>
>> In a financial excel spread sheet, a manager has to keep track on the total
>> money
>> every day. If the money is exceed a certain value he has to take actions.
>>
>> How to make this automation by flashing or turn red or even better send
>> email?
>>
>> Thanks
>> Daniel
>>
>>

Thanks Ron
I tried this by copying and paste to sheet tab/view code but I have to run
macro manually. How to be automation when the value of a cell exceed exp 200

"Ron de Bruin" wrote:

> Or use Outlook 2007 or CDO or redemption
>
> See
> http://www.rondebruin.nl/mail/prevent.htm
>
>
> --
>
> Regards Ron de Bruin
> http://www.rondebruin.nl/tips.htm
>
>
> "ryguy7272" <(E-Mail Removed)> wrote in message news:CF928B43-57FD-4A59-BE88-(E-Mail Removed)...
> > Ron de Bruin is pretty much the master of this stuff!!
> > http://www.rondebruin.nl/mail/change.htm
> >
> > Oh, and this is worth a look too:
> > http://www.contextmagic.com/express-clickyes/
> > I don't think you will be sending multiple emails, but if you do, run that
> > small utility. Try sending multiple emails without it, and try sending
> > multiple emails with it...it's magic....
> >
> > Regards,
> > Ryan---
> >
> > --
> > RyGuy
> >
> >
> > "Daniel" wrote:
> >
> >>
> >> How to write a macro so that if a value in a cell is exceeded, the excel
> >> window will flash or turn to red?
> >>
> >> In a financial excel spread sheet, a manager has to keep track on the total
> >> money
> >> every day. If the money is exceed a certain value he has to take actions.
> >>
> >> How to make this automation by flashing or turn red or even better send
> >> email?
> >>
> >> Thanks
> >> Daniel
> >>
> >>
>

See
http://www.rondebruin.nl/mail/change.htm

--

Regards Ron de Bruin
http://www.rondebruin.nl/tips.htm


"Daniel" <(E-Mail Removed)> wrote in message news:5BA0AF34-723A-49CA-B381-(E-Mail Removed)...
> Thanks Ron
> I tried this by copying and paste to sheet tab/view code but I have to run
> macro manually. How to be automation when the value of a cell exceed exp 200
>
> "Ron de Bruin" wrote:
>
>> Or use Outlook 2007 or CDO or redemption
>>
>> See
>> http://www.rondebruin.nl/mail/prevent.htm
>>
>>
>> --
>>
>> Regards Ron de Bruin
>> http://www.rondebruin.nl/tips.htm
>>
>>
>> "ryguy7272" <(E-Mail Removed)> wrote in message news:CF928B43-57FD-4A59-BE88-(E-Mail Removed)...
>> > Ron de Bruin is pretty much the master of this stuff!!
>> > http://www.rondebruin.nl/mail/change.htm
>> >
>> > Oh, and this is worth a look too:
>> > http://www.contextmagic.com/express-clickyes/
>> > I don't think you will be sending multiple emails, but if you do, run that
>> > small utility. Try sending multiple emails without it, and try sending
>> > multiple emails with it...it's magic....
>> >
>> > Regards,
>> > Ryan---
>> >
>> > --
>> > RyGuy
>> >
>> >
>> > "Daniel" wrote:
>> >
>> >>
>> >> How to write a macro so that if a value in a cell is exceeded, the excel
>> >> window will flash or turn to red?
>> >>
>> >> In a financial excel spread sheet, a manager has to keep track on the total
>> >> money
>> >> every day. If the money is exceed a certain value he has to take actions.
>> >>
>> >> How to make this automation by flashing or turn red or even better send
>> >> email?
>> >>
>> >> Thanks
>> >> Daniel
>> >>
>> >>
>>

Hi Ron
Why I have to hit yes to allow to send email message. How to make it
automatically?
Daniel

"Ron de Bruin" wrote:

> See
> http://www.rondebruin.nl/mail/change.htm
>
> --
>
> Regards Ron de Bruin
> http://www.rondebruin.nl/tips.htm
>
>
> "Daniel" <(E-Mail Removed)> wrote in message news:5BA0AF34-723A-49CA-B381-(E-Mail Removed)...
> > Thanks Ron
> > I tried this by copying and paste to sheet tab/view code but I have to run
> > macro manually. How to be automation when the value of a cell exceed exp 200
> >
> > "Ron de Bruin" wrote:
> >
> >> Or use Outlook 2007 or CDO or redemption
> >>
> >> See
> >> http://www.rondebruin.nl/mail/prevent.htm
> >>
> >>
> >> --
> >>
> >> Regards Ron de Bruin
> >> http://www.rondebruin.nl/tips.htm
> >>
> >>
> >> "ryguy7272" <(E-Mail Removed)> wrote in message news:CF928B43-57FD-4A59-BE88-(E-Mail Removed)...
> >> > Ron de Bruin is pretty much the master of this stuff!!
> >> > http://www.rondebruin.nl/mail/change.htm
> >> >
> >> > Oh, and this is worth a look too:
> >> > http://www.contextmagic.com/express-clickyes/
> >> > I don't think you will be sending multiple emails, but if you do, run that
> >> > small utility. Try sending multiple emails without it, and try sending
> >> > multiple emails with it...it's magic....
> >> >
> >> > Regards,
> >> > Ryan---
> >> >
> >> > --
> >> > RyGuy
> >> >
> >> >
> >> > "Daniel" wrote:
> >> >
> >> >>
> >> >> How to write a macro so that if a value in a cell is exceeded, the excel
> >> >> window will flash or turn to red?
> >> >>
> >> >> In a financial excel spread sheet, a manager has to keep track on the total
> >> >> money
> >> >> every day. If the money is exceed a certain value he has to take actions.
> >> >>
> >> >> How to make this automation by flashing or turn red or even better send
> >> >> email?
> >> >>
> >> >> Thanks
> >> >> Daniel
> >> >>
> >> >>
> >>
>

See
http://www.rondebruin.nl/mail/prevent.htm

--

Regards Ron de Bruin
http://www.rondebruin.nl/tips.htm


"Daniel" <(E-Mail Removed)> wrote in message news:3BB992E1-ABF7-4A1A-B75E-(E-Mail Removed)...
> Hi Ron
> Why I have to hit yes to allow to send email message. How to make it
> automatically?
> Daniel
>
> "Ron de Bruin" wrote:
>
>> See
>> http://www.rondebruin.nl/mail/change.htm
>>
>> --
>>
>> Regards Ron de Bruin
>> http://www.rondebruin.nl/tips.htm
>>
>>
>> "Daniel" <(E-Mail Removed)> wrote in message news:5BA0AF34-723A-49CA-B381-(E-Mail Removed)...
>> > Thanks Ron
>> > I tried this by copying and paste to sheet tab/view code but I have to run
>> > macro manually. How to be automation when the value of a cell exceed exp 200
>> >
>> > "Ron de Bruin" wrote:
>> >
>> >> Or use Outlook 2007 or CDO or redemption
>> >>
>> >> See
>> >> http://www.rondebruin.nl/mail/prevent.htm
>> >>
>> >>
>> >> --
>> >>
>> >> Regards Ron de Bruin
>> >> http://www.rondebruin.nl/tips.htm
>> >>
>> >>
>> >> "ryguy7272" <(E-Mail Removed)> wrote in message news:CF928B43-57FD-4A59-BE88-(E-Mail Removed)...
>> >> > Ron de Bruin is pretty much the master of this stuff!!
>> >> > http://www.rondebruin.nl/mail/change.htm
>> >> >
>> >> > Oh, and this is worth a look too:
>> >> > http://www.contextmagic.com/express-clickyes/
>> >> > I don't think you will be sending multiple emails, but if you do, run that
>> >> > small utility. Try sending multiple emails without it, and try sending
>> >> > multiple emails with it...it's magic....
>> >> >
>> >> > Regards,
>> >> > Ryan---
>> >> >
>> >> > --
>> >> > RyGuy
>> >> >
>> >> >
>> >> > "Daniel" wrote:
>> >> >
>> >> >>
>> >> >> How to write a macro so that if a value in a cell is exceeded, the excel
>> >> >> window will flash or turn to red?
>> >> >>
>> >> >> In a financial excel spread sheet, a manager has to keep track on the total
>> >> >> money
>> >> >> every day. If the money is exceed a certain value he has to take actions.
>> >> >>
>> >> >> How to make this automation by flashing or turn red or even better send
>> >> >> email?
>> >> >>
>> >> >> Thanks
>> >> >> Daniel
>> >> >>
>> >> >>
>> >>
>>