Thanks everyone for all the great suggestions. Will give them a try today.
Again, appreciate it very much!

"NickHK" wrote:

You can use the older Macro4 call.
Create a new name, maybe "CalcMode" and set it "=GET.DOCUMENT(14)"

Then in you worksheet you can enter "=CalcMode" whereever you need it.

You can enhance the formula to to return a string instead if desired.

NickHK

"Paige" wrote in message
...
I need to have a cell that tells the user what the current state of
calculation is (i.e., is it set to automatic or manual); this would have
to
change automatically whenever calculation is changed from auto to manual
or
vice versa. The workbook is normally set to auto, but the user can change
the status manually back and forth. Where/how can I insert code that
would
be triggered to update whenever calc is changed, and look to see what it
was
changed to? Tried putting some code under various worksheet and workbook
events, but keep getting those pesky little 'out of stack space' messages!