PDA

View Full Version : Calculation On/OFF Basis On Selection



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

GarysStudent
10-14-2012, 09:18 AM
Once the calculation mode is change, the change applies to all sheets.

Teeroy
10-15-2012, 10:42 PM
Have a look at http://www.vbaexpress.com/forum/showthread.php?t=43683.