Run macro after cell is updated

[mcelligott]

Hello,

I have a macro that I would like to run automatically if a cell is updated in excel. Does anyone know how this can be accomplished?

The macro updates all the worksheet headers (all 20) to what is in A1 of the first sheet. I currently have it attached to a button but would like to make the macro run automatically if the field is changed.

Any help would be greatly appreciated.

Thanks,

Bob

 

[Gavona]

Post in forum707 please. But first have a look at events in VBA help and within that forum.

Gavin