Good morning all,

I'd like to start by saying that I am entirely unfamiliar with VBA and am fairly new to Excel. I have a spreadsheet that my group enters information into. There are formulas to calculate a percentage based on dates entered that dump to a summary work sheet. It is a continuous work in progress. I have each sheet protected and the whole book protected and shared so that multiple people can enter and save information at the same time. I always review the changes and either approve or reject them. This is more to prevent or undo accidental changes or changes that affect something else.

What I would like to know is, how would I get Excel (2007 by the way) to log all activity to either a separate sheet in the same workbook or, ideally, a separate workbook in the same folder. This is on a shared drive as well. Thank you in advance for any help that you can offer!