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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

i need to find the exact location of macro to paste in the existing macro need to get the out put co 0
Excell 2000 macro will not open file! 1
Macro for active sheet only 4
Excel 2007: Help creating a macro that will run Solver? 3
Close Excel with a Macro 2
Wait statement in macro 1
Spreadsheet macro stopped working! 5
2003 Macro in a 2007 World 1

Back
Top