Macro in Background

  • Thread starter Thread starter Hager
  • Start date Start date
H

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
 
application.screenupdating = false
'your code here
application.screenupdating = true
 
Back
Top