deactivate automatic calcul

[tiguil]

Is there a way to deactivate the automatic calcul on a specefic sheet. If i have sheet "A" and "B", what would be the code to deactivate the calcul on sheet "B". Is there also a way to put it back on when sheet "B" is selected

 

[KMKfan]

I don't think there is a way to do it for just a specific worksheet.

In sheet A (or sheet B) in the VBE:

Private Sub WorkSheet_Activate()

With Application
        .Calculation = xlManual
End With
End Sub

Private Sub WorkSheet_Deactivate
    With Application
        .Calculation = xlAutomatic
    End With
End Sub

This changes the autocalc for the entire workbook.

ie: When sheet B is activated, sheet A will autocalc with the rest of the workbook. When sheet A is activated, neither sheet will autocalc.