Track Changes without sharing the workbook

Hi,

I have a requirement to track changes made to a workbook. To use the track changes functionality I need to share the workbook.
Sharing the workbook gives me a problem as I have a protected sheet in the workbook that gets updated when a certain macro runs

Please Login or Register  to view this content.

The above line fails when the workbook is shared, I was advised to use

Please Login or Register  to view this content.

however this wipes the tracking history as it temporarily turns off tracking

Anyone know how I can get around this ?

Here is a way in VBA. Basically, it tracks all changes made to the workbook on a separate hidden worksheet.

Did you mean to attach something or are you just saying there is a way in VBA ?

Thanks

Whilst googlin found this http://www.ozgrid.com/VBA/track-changes.htm, I'll test it out and let you know if it works.

Thanks

LOL! Sorry, that is the link I meant to post. OOPS!

Yes it works !

Any updates on this post or related. Pasted the code in and nothing happens. What do you do next? is there only certain parts of the code that gets pasted. Attempted to save but said something that you cannot save on a macro free book.
Thanks