Nov 29 2009

Macro to Disable Cell Calculations on a Sheet

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.

[ad#in-post-ad]
Turn Off Calculations in VBA
Below is the simple line of VBA code to turn off calculations on the currently active sheet.

Sub DisableCalc()

ActiveSheet.EnableCalculation = False

End Sub

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.

More Excel Tips

Did you find this post helpful? Try signing up for our free daily tips.

Enter your email address: 

          

3 Comments on this post

Trackbacks

  1. Automobile India said:

    I need to know how to do the calculation to estimate the size of the cell as seen through the microscope in microns. This is due on Monday and I totally forget how to do it.

    December 2nd, 2009 at 5:58 am
  2. Automobile India said:

    Is it possible to have a person disable your cell phone also listen in on your ongoing converstions?

    January 2nd, 2010 at 2:24 am
  3. Automobile India said:

    example of using the selected item in one list box control on a UserForm to determine the list that will populate a second list box… KB#213748. Keywords: VBA, UserForm, Web, Window

    March 3rd, 2010 at 1:36 am

LEAVE A COMMENT

Subscribe Form

Subscribe to Blog

Sign Up for Excel Hints

Free updates with Excel Hints, Tips & Tricks

Categories

Archives