Macro in Background
 

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

Macro in Background
 

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

Macro in Background
 

job done, nice one cheers H

"Jim Thomlinson" wrote:

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