OK Guys, back to the question for mc84.....

This sounds like you want to track all things so you might can UNDO them....
Look at http://www.jkp-ads.com/Articles/UndoWithVBA00.asp or
http://www.j-walk.com/ss/excel/tips/tip23.htm

Now instead of only logging what was done you should log all things done to a log/text file. Perhaps that is what you are trying to do.