| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| macro for copying background color | Excel Discussion (Misc queries) | |||
| How to work with macro in background | Excel Discussion (Misc queries) | |||
| How do I run a macro in the background | Excel Discussion (Misc queries) | |||
| Macro that runs in the background | Excel Discussion (Misc queries) | |||
| How can I run a macro in the background whilst a UserForm is visib | Excel Discussion (Misc queries) | |||
Linear Mode
