Right click the sheet tabview codeworksheet_change event.
--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"Jeremy" wrote in message
...
How do you have a macro run on its own when data is changed in the cell it
is
referencing to?

Thank you
Jeremy