Disable/enable recalc
Hi,
You can disable manually or with code
Sub Yoursub()
Application.Calculation = xlCalculationManual
'your code
Application.Calculation=xlCalculationAutomatic
or
Office button - Excel Options - Fromulas and set to manual or automatic
Or attach the code above to a button on the Quick Access Toolbar (QAT) or on
the worksheet
Mike
"Kjeldc" wrote:
I have workbook with lots of sheets and formulas and it takes forever to
recalc the workbook, whenever a new entry is made in a cell. Is it possible
to disable recalc for the whole workbook, and then start it with a
controlbutton?
Vista Ultimate/Office 2007
--
My programming is self-taught and
my teacher was not very experienced. :-)
cheers,
Kjeld
|