Activate a macro when the value of a linked cell changes

[Sarangsood]

I have a macro names "run" ... i want to activate it when the value of a1 changes ... nd a1 is linked from sheet2!A1 ....

[vasantjob]

I have a macro names "run" ... i want to activate it when the value of a1 changes ... nd a1 is linked from sheet2!A1 ....

You can put the macro in the worksheet change event.

[Sarangsood]

can u give me the entire code ?? im not that fluent in vba ... i have recorded a macro and i want it to run weneva the value changes in a1 (which is linked from another sheet).

thnx