r_know
10-14-2012, 08:05 AM
Dear All,
I have required the VBA code on basis,
If B1 is equal to 1 then,
Application.Calculation = xlCalculationAutomatic
If B1 is equal to 2 then,
Application.Calculation = xlCalculationManual
Sheet tab Name "DTS"
So on selection, 1 and 2, calculation mode act on "DTS" sheet Only (not others sheets).
Regards,
Rahul
I have required the VBA code on basis,
If B1 is equal to 1 then,
Application.Calculation = xlCalculationAutomatic
If B1 is equal to 2 then,
Application.Calculation = xlCalculationManual
Sheet tab Name "DTS"
So on selection, 1 and 2, calculation mode act on "DTS" sheet Only (not others sheets).
Regards,
Rahul