When I run a lengthy piece of code the sheet immediately calculates even
though a calculation (which takes quite a while) has not been included in
the code. Is there a way to prevent this from happening?

Pat