Hi all,
I have been playing around with the Track Changes facility in Excel and have noticed that the Highlight Changes settings do not save when I close the file. This is frustraing because I want the "When: All" and "List changes on new sheet" settings to stick but they revert to defaults when I reopen the spreadsheet. Is there someway to make the settings stick? Perhaps a macro of some sort..
Thanks.
I have been playing around with the Track Changes facility in Excel and have noticed that the Highlight Changes settings do not save when I close the file. This is frustraing because I want the "When: All" and "List changes on new sheet" settings to stick but they revert to defaults when I reopen the spreadsheet. Is there someway to make the settings stick? Perhaps a macro of some sort..
Thanks.