Hi xt

not to sure if you can halt autocalcs on specific rows, columns or
individual cells,.

you can control wheter the woorkbook itself does or does not autocalc.

you could have let's say 2 cmdbtns, one = off, the other = on

Sub Calc_Off()
With Application
.Calculation = xlManual
End With
End Sub

Sub Calc_On()
With Application
.Calculation = xlAutomatic
End With
End Sub

You could also place something in the

Private Sub Workbook_Open()

With Application
.Calculation = xlManual
End With
End Sub

Private Sub Workbook_BeforeClose(Cancel As Boolean)

With Application
.Calculation = xlAutomatic
End With
End Sub

HTH
Mick.