one way might be to use this function:

Function calc()

If Application.Calculation = xlCalculationManual Then
calc = "Manual"
ElseIf Application.Calculation = xlCalculationAutomatic Then
calc = "Automatic"
Else
calc = "SemiAutomatic"
End If

End Function


and then use 1 of existing buttons to change the setting

to insert this function press ALT+F11 to go Visual Basic window, then
Insert-Module and paste this code

otherwise you would have to change all existing macros to reflect the
current calculation setting


On 21 Kwi, 10:48, dhstein wrote:
I have 2 radio buttons - one marked "Calc On" *and one marked "Calc Off". *
The user can turn auto calc on or off. *There are other macros in the
spreadsheet - and I also turn calc off during those macros and then turn it
back on. *What I want is to be able to detect what the current setting is and
then set it to that at the end of macro execution. *So if Calc is "OFF" then
at the end of the macro I want to leave it off. *Any advice is appreciated.