alt-t,o,c (enough times to get to the Calculation tab), m (enter)
You may want to record a macro that toggles calculation and then assign that
macro a nice shortcut key--kind of like:
Option Explicit
Sub toggleCalc()
Dim myStr As String
With Application
Select Case .Calculation
Case Is = xlCalculationAutomatic
.Calculation = xlCalculationManual
myStr = "manual"
Case Else:
.Calculation = xlCalculationAutomatic
myStr = "automatic"
End Select
End With
MsgBox "Calculation set for: " & myStr
End Sub
(there's a third calculation mode, but I don't use it. (I'd find it irrating to
cycle through xlcalculationsemiautomatic.)
FOG wrote:
I am not fond about using a mouse in excel and was trying to found a way to
change the autocalculation function with the keyboard but haven't found
any... can anyone please help me about this?
Thank you
--
Dave Peterson
|