Macro to Disable Cell Calculations on a Sheet
- 3 Comment
If you’ve ever had a sheet in your project that has a number of formulas with calculations, you’ve no doubt noticed the slowdown that occurs when saving your spreadsheet or editing a formula. Excel has a property that can be adjusted within a macro that allows you to turn on and off the calculations on a spreadsheet.
Turn Off Calculations in VBA
Below is the simple line of VBA code to turn off calculations on the currently active sheet.
ActiveSheet.EnableCalculation = False
That’s it. You can also specify which sheet you would like to disable calculations for by using Sheets(“SheetName”).EnableCalculation = False. To re-enable calculations just change the False to True in a 2nd macro.
This can also be achieved using the tools menu in Excel . Using this trick will speed up your work by not making you wait for calculations to update all the time, as well as decreasing save time. Just don’t forget to turn it back on before you need to use the calculations.