Disable the Functions in Excel while Macro Runs??? 1

[cjhepburn]

How Do I disable the functions in Excel while a macro executes?
As I step through the macro, it goes back and recalculates these functions after every step.

 

[Ruairi]

Try

Application.Calculation = xlCalculationManual

Ruairi

Could your manufacturing facility benefit from real time process monitoring? Would you like your employees to be able to see up to the minute goal and actual production?
For innovative, low cost solutions check out my website.

http://www.plccontroltechnologies.com

 

[ratman]

application.enableevents=false


then do your thing

then when it can be turned back on put it back in as


application.enableevents=true