| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Macro - Prevent screen refresh
Is there a way to prevent the workbook screen display getting refreshed as a
macro runs, and make the macro run in the background without refreshing the worksheet display. Maybe it runs faster that way. Rgds, |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Macro - Prevent screen refresh
You are quite correct. try this:
application.screenupdating=false ' 'your code here ' application.screenupdating=true "Bharath Rajamani" wrote in message ... Is there a way to prevent the workbook screen display getting refreshed as a macro runs, and make the macro run in the background without refreshing the worksheet display. Maybe it runs faster that way. Rgds, |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Macro - Prevent screen refresh
Bharath:
Application.ScreenUpdating = False '... 'Your code in Here '... Application.ScreenUpdating = True HTH Duncan Bharath Rajamani wrote: Is there a way to prevent the workbook screen display getting refreshed as a macro runs, and make the macro run in the background without refreshing the worksheet display. Maybe it runs faster that way. Rgds, |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Prevent refresh in certainpivot tables in workbook | Excel Worksheet Functions | |||
| prevent big white screen | Excel Worksheet Functions | |||
| Prevent Screen from flicking from one place to the next | Excel Programming | |||
| Screen Refresh | Excel Discussion (Misc queries) | |||
| running a macro on every refresh of the screen | Excel Programming | |||
Linear Mode
