| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Can I keep the screen from jumping when running a macro?
I'm running a macro that is cutting and pasting and selecting cells
from all over my spreadsheet. When it is running, my screen is jumping all over so quickly that i cannot see anything. Is it possible to make the screen stay put? TIA, JasonK |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Can I keep the screen from jumping when running a macro?
Try this:
Application.ScreenUpdating = False your code Application.ScreenUpdating = true |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Can I keep the screen from jumping when running a macro?
worked perfectly.
thanks a ton. jasonk On 18 Mar 2006 23:52:46 -0800, "ward376" wrote: Try this: Application.ScreenUpdating = False your code Application.ScreenUpdating = true |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Hide screen movements when a macro is running | Excel Discussion (Misc queries) | |||
| How do I stop the screen from jumping | Excel Discussion (Misc queries) | |||
| Private sub causes too much screen jumping | Excel Discussion (Misc queries) | |||
| running a macro on every refresh of the screen | Excel Programming | |||
| How to stop screen blinking when running macro | Excel Programming | |||
Linear Mode
