tracking changes with insert comment

[samst]

Hi Again all, second time poster here.

I was wondering if anyone knows of away to programatically Insert
Comment for a certain range of cells into that cell when the value
changes so that the comment Will read: "Old Value was:###"
Thanks again!!

PS All the cells have conditional formatting (don't know if that makes
a difference)

 

[Robert Rosenberg]

Consider a non VBA method using the Tools-->Track Changes feature. It shares
the workbook, but if it's on your network drive or local hard drive no one
should be able to open it. You can also restrict who views it if others will
have access to it.