Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
optimization question
I saw some code once that turned off screen refreshes in a workbook until a
macro complete running. I can't remember how that was done. Does anyone have any ideas? Thanks |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
optimization question
At the start of the macro set:
application.ScreenUpdating=False At the end (or in your eeeor trap) set: application.ScreenUpdating=true "ybazizi" wrote: I saw some code once that turned off screen refreshes in a workbook until a macro complete running. I can't remember how that was done. Does anyone have any ideas? Thanks |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
optimization question
Thanks! That did the trick.
"AA2e72E" wrote: At the start of the macro set: application.ScreenUpdating=False At the end (or in your eeeor trap) set: application.ScreenUpdating=true "ybazizi" wrote: I saw some code once that turned off screen refreshes in a workbook until a macro complete running. I can't remember how that was done. Does anyone have any ideas? Thanks |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Table formula optimization Question | Excel Discussion (Misc queries) | |||
Seo , Search Engine Optimizer , Seo Search engine Optimization , search engine optimization services, SEO Consulting | Excel Worksheet Functions | |||
Seo , Search Engine Optimizer , Seo Search engine Optimization , search engine optimization services, SEO Consulting | Excel Discussion (Misc queries) | |||
Optimization question | Excel Discussion (Misc queries) | |||
Optimization question: how to bypass copy and paste | Excel Programming |