Track changes without sharing??

Hello everyone,

I have another problem on my hands. I have an excel file which contains macros, that are needed and used, that also needs the ability to be able to track changes. So far the only known method I know of tracking changes is by using the track changes functionality in Excel...however that requires that the macros be disabled because it forces the excel file to be "shared". More importantly, it turns off my ability to use the Pivot Tables, which are key to the functionality of the file.

Is there anyother method?? VBA perhaps??

Many thanks,
Matt