speeding up calculations

Put a macro in Workbook_Open under ThisWorbook in VB Explorer that will turn off the AutoCalc option when the file is opened. Here is that code:


Then create another macro and insert into a module. This macro will turn the AutoCalc feature back on. Here is that code:


You can create a button on the Excel spreadsheet and attach the macro to it, so that the user can click the button to turn the AutoCalc feature back on whenever they want.
This message was edited by jmiskey on 2003-01-30 15:33

set calculation to manual via Tools -> Options-> Calculation. Then you'll need to hit the F9 key when you want it to recalculate

you could also put a macro like this in your workbook and assign it to a button on the worksheet:

Sub CalcChange()
'
If Application.Calculation = xlCalculationAutomatic Then Application.Calculation = xlManual

If Application.Calculation = xlManual Then
Application.Calculation = xlCalculationAutomatic
Application.Calculate
End If

End Sub

OK, I'm starting to see the light. However, I am still having trouble and am trying to start over w/o any macros. I have deleted all macros in my file but each time I open it, it still asks if I want to enable/disable. How can I delete all traces of past macros?

These suggestions we sent you ARE macros. If you delete them, you want able to use them and do what you asked (unless you manually turn the AutoCalc off through the Tools menu).

To view all the macros, go into your file project in Project Explorer and expand it by clicking on the plus sign (if it shows a negative sign, it is already expanded).

Macros can show up in Modules, or under ThisWorkbook, and each Sheet (as well as UserForms if you are using them).

Double-click each of these and you maro code should pop-up. You can then delete each one, if you really want to.