But you can use a Worksheet_change event handling macro that will run
based upon the results of a target cell.
A Google search on Worksheet_change should produce lots of examples
that might be tailored to your requirements. Or you could post more
details of what you intend.
--
Regards
Norman Harker MVP (Excel)
Sydney, Australia
(e-mail address removed)
Excel and Word Function Lists (Classifications, Syntax and Arguments)
available free to good homes.
Ben said:
Can you put macros into formulas to run automatically if special