Tom,
Thanks for the reply. The value is updated every second using the built in
database query tools. The database is MS SQL - if that has any bearing.
Basically this discrete value is originates in a controller for a production
line and should drive a macro that pulls in data from three different
databases and then prints a report. All automatic - thus the dilemma. The
macro and database connectivity all works and I can manually run the macro to
generate the report and print - just need this last piece. Any ideas?

"Tom Ogilvy" wrote:

How is the value going to change?

If by editing manually, can we assume that if the cell is edited, the macro
should run. (if it had a value of 2 and it still had a value of 2 after
editing, should the macro run?).

--
Regards,
Tom Ogilvy

"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!!!!