Excel Track Changes

[bellboy]

Issue:

I have created an Excel template (.xlt) and enable the "Track Changes" to keep an audit trail of that file. However, every time I open the file, the Track Changes settings go back to the default settings.

I would like the following options when I open that file:

When: checked off - for "All"
Who: checked off - for "All"

Highlight changes on screen - checked off
List changes on new sheet - checked off

Can a macro do this?

Thanks!