Slow calcs with VBA open?

[CedarTree]

Hi - I have an XLSM file running and it calculates REALLY slowly when I'm viewing code. When I close the view code window, the calculation happens very quickly. You can the VBA window flashing as if it's updating the screen as it calculates. Any cheats to make re-calculating faster with VBA open?

 

[Ranman256]

turn off screen updates:
Application.ScreenUpdating = false

 

[CedarTree]

Cool - I added a button - turns off updating / calculates / turns it back on. Thanks!

 

[Isaac]

This is very interesting, and something I've never experienced (or at least, noticed) before. Thanks for sharing. So this had nothing to do with VBA code running ... simply that if you had the VBA project window open at all, then regular worksheet calculations/formulas were extra slow to refresh. Very interesting! I wonder why.