Ron,
You're a genius!!!!! Works like a charm - I'll test it out on the full
production system in the morning, but, no doubt will work fine. Many
thanks!!!

"Ron de Bruin" wrote:

Hi JD

You can use the change event
http://www.cpearson.com/excel/events.htm

Here is a example of the change event that run a macro
http://www.rondebruin.nl/mail/change.htm

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



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



"JD" wrote in message ...
Is there any way to automatically run a macro in excel based on the value of
a cell in that workbook? i.e. the value changes from 0 to 1 = run macro.
Anyone have a copy of code that does this? Using VBA and don't have full
blown VB - thanks!!!!