Macro in Background

[Hager]

Hi All

Bit of a weird one but I have a big spreadsheet which does a large number of
calculations (using a macro). The macro flicks across the spreadsheet
(opening and shutting different sheets). which last about 2/3 mins.

Is there away of running the macro in the background so it stays on the
front page while it does the calculations?

Any help appreciated

 

[Jim Thomlinson]

application.screenupdating = false
'your code here
application.screenupdating = true

 

[Hager]

job done, nice one cheers H

application.screenupdating = false
'your code here
application.screenupdating = true