We help IT Professionals succeed at work.

Turn off automatic calculations in MS Excel

gracie1972
gracie1972 asked
on
Is there a way to add a line to a macro to turn off automatic calculations in excel?  I have a macro that imports files when you click a button, however if manual calculation is on it takes longer.
Comment
Watch Question

"There is still no cure for the common birthday." ~John Glenn
Most Valuable Expert 2017
Distinguished Expert 2018
Commented:
Application.Calculation = xlCalculationManual
Martin Liss"There is still no cure for the common birthday." ~John Glenn
Most Valuable Expert 2017
Distinguished Expert 2018

Commented:
And to change it back

Application.Calculation = xlCalculationAutomatic

Author

Commented:
Thank you!
Martin Liss"There is still no cure for the common birthday." ~John Glenn
Most Valuable Expert 2017
Distinguished Expert 2018

Commented:
You're welcome and I'm glad I was able to help.

In my profile you'll find links to some articles I've written that may interest you.
Marty - MVP 2009 to 2015