VBA: Is it possible to turn off autocalculate for one sheet only?

[Captain Smith]

Using VBA, is it possible to turn off the autocalculate for one sheet only?
Sheet3 has a lot of calculating formulas, I just want to disable this one sheet so that
the autocalculate works on the other sheets (the macro needs those sheets to autocalculate).

If this cannot be done, as an alternative, is it possible at the beginning of the macro that the cells with formulas in a certain range can be added a ' at the beginning of the formula string, then at the end of the macro put the ' back on, to prevent a bunch of needless calculating during the running of the macro?


Thanks.

 

[Legacy 68668]

How about set Application.Calcuation to xlmanual then calculate the sheet that you want.

e.g sheet1.calculate

 

[Captain Smith]

Thank you. So simple that I did not even consider it.

 

[pgc01]

Hi

If you want the other worksheets to keep calculating automatically, you can also use:

sheet3.EnableCalculation=False

 

[CTK123]

Hi

If you want the other worksheets to keep calculating automatically, you can also use:

sheet3.EnableCalculation=False

Sorry for the necrobump. Which VBA section do you put this? Would this just be a new module?

 

[pgc01]

Hi

You can place it wherever you want. As soon as it's executed the sheet will stop updating automatically until you enable calculation again.

For ex., if you paste it into the Open event of the workbook it will always be executed when you open the workbook.