Shortcut Tools - Options - Calculation

[Vince]

I was wondering if somebody would know the shortcut key to toggle between
"Tools - Options - Calculation - Automatic" and "Tools - Options -
Calculation - Manual". Do I have to assign one or is there already one? If
the former, how should I go about it? I know that I could push a Shift+F9 to
recalculate but I would also like to do the toggling.

Thankyou for any response.

Vince

 

[Dave Peterson]

You could set up a macro that toggles between calculation modes.

Option Explicit
Sub toggleCalculation()

Dim msg As String

With Application
If .Calculation = xlManual Then
.Calculation = xlAutomatic
msg = "automatic"
Else
.Calculation = xlManual
msg = "manual"
End If
End With

MsgBox "Calculation set for: " & msg

End Sub

Assign a shortcut key to it.

If you're new to macros, you may want to read David McRitchie's intro at:
http://www.mvps.org/dmcritchie/excel/getstarted.htm

 

[Vince]

THank you Dave. It works good.

You could set up a macro that toggles between calculation modes.

Option Explicit
Sub toggleCalculation()

Dim msg As String

With Application
If .Calculation = xlManual Then
.Calculation = xlAutomatic
msg = "automatic"
Else
.Calculation = xlManual
msg = "manual"
End If
End With

MsgBox "Calculation set for: " & msg

End Sub

Assign a shortcut key to it.

If you're new to macros, you may want to read David McRitchie's intro at:
http://www.mvps.org/dmcritchie/excel/getstarted.htm