bellboy
01-03-2006, 04:01 PM
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!
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!