help w/Excel vb code

[pluz]

I need help with vb in Excel to check if workbook's Track Changes While Editing option (Tools>Track Changes>Highlight Changes) is turned ON. If yes, then I will alert the user with a message. Thanks for any help I can get with this one.

Note: HighlightChangesOnScreen prop does not work as users may have track changes while editing turned on and highlight changes on screen turned off.

 

[RoyVidar]

Hi!

This is Access Forms forum. Although I know a lot of the members frequenting this forum also have excellent Excel knowledge, you might increase your chanses of getting an anwer if posting in forum707.

Roy-Vidar