How do you turn auto-cal on...

[angelshare1]

...with a button. You didn't think this would be an easy question did you?

I have a few spreadsheets that jam up my computer when auto calc is on. It's a pain to go to tools-options everytime I go into one of these which is often. Is there a way to get a button on my toolbar for turning auto calc on and off?

Thanks!

 

[RoryA]

Yep - the basic code would be:

   With Application
      If .Calculation = xlCalculationAutomatic Then
         .Calculation = xlCalculationManual
      Else
         .Calculation = xlCalculationAutomatic
      End If
   End With

 

[Joe4]

Welcome to the Board!

You could store Rory's code in your Personal Macro Workbook, then create a Custom Toolbar button to run it. Then it should be accessible to you whenever you have Excel open on your computer.

Otherwise, you will need to put it in each workbook that you want to use it from.

 

[RoryA]

If you're interested, I have a basic add-in that I use that adds a toolbar with one button that toggles the calculation mode and displays its current status. If you want it, PM me your email address.

 

[Jonmo1]

You can also right click your toolbar - customize
find the "Calculate Now" button in the Tools Category.
Drag that directly on your toolbar.


Never mind, not quite the same thing you're looking for