Help! Alternative Tracking Solution???

[matt4003]

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

[theDude]

Matt,

Not a problem. From Excel help :

Limitations of shared workbooks
Some features are not available when you use a shared workbook...

In a shared workbook, you cannot do the following:

Macros

Write, change, view, record, or assign macros. However, you can record operations in a shared workbook into a macro stored in another workbook that isn't shared. In a shared workbook, you can run macros that were created before you shared the workbook; although if you run a macro that includes an unavailable operation, the macro stops running when it reaches the unavailable operation.

If you need to edit them, turn off file sharing which erases change history if it's enabled.

Hope this helps,
theDude