View Single Post
  #2   Report Post  
Dave Peterson
 
Posts: n/a
Default

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