How to track changes in the workbook?

[pkohli]

Hi

I have a file that has 50 sheets and is updated by every week by staff and send back to me via email....how can I track the changes made in the sheet?

 

[lenze]

Can you not use the Tools>Track Changes option? You may need to put the file on a shared drive instead of using email. If you ONLY want to track the LAST change of each cell, you can add a comment. See my code posted here.
http://www.mrexcel.com/board2/viewtopic.php?p=1088487#1088487

lenze