I have written some code to provide a right-click shortcut to toggle
Auto/Manual calculation modes. This code changes the State property on the
menu to provide a check mark if Manual calculation is on. This all works
fine, but how would I know if someone used the 'normal'
Tools/Options/Calculation to change calculation modes (and therefore be able
to update my menu item)? I looked at Application Events but didn't think
any of them would trigger based on changing calculation modes. Is there a
way to accomplish this? I am using XP SP2 and XL2003. Thanks in advance
for any help provided.