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

Jim Thomlinson


"Hager" wrote:

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