Another good macro for one's personal macro workbook. This one toggles between Manual and Automatic calculations. Hopefully your spreadsheets aren't so large that you need to use this often, but it prevents annoying autocalcs. I like to assign it to the keyboard shortcut CTRL + ALT + M.

vbaToggleManualCalcs

Public Sub ToggleManualCalcs()
  If Application.Calculation = xlCalculationAutomatic Then
    Application.Calculation = xlCalculationManual
  Else
    Application.Calculation = xlCalculationAutomatic
  End If
End Sub