Change excel cell when changed

[koresnordic]

One of the directors has asked if there is a way to show which cells have been changed in an excel spreadsheet. I guess he wants to change the format of the cell to show it has been changed. I have looked at this thread:

http://www.tek-tips.com/viewthread.cfm?qid=584876

Which seems to do this, but it also clears it when you move off the cell. How do I modify this to keep the formatting change?



Graham

 

[xlbo]

Tools>Track changes ???

Rgds, Geoff

Three things are certain. Death, taxes and lost data. DPlank is to blame

Please read FAQ222-2244 before you ask a question

 

[koresnordic]

erm, erm
/slaps head

Thx.

Graham