| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Supress display of multiple steps in Macro
I'm a Macro NOVICE. i've recorded a macro which clears out cells, then
copies a portion from another screen, and then does some more manipulations. I'm sure there is a command to supress the everchanging display as the macro executes, but I don't know how to find it. I have no manuals, and I have no help files installed on my pc. |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Supress display of multiple steps in Macro
Hi MicroMain,
Try: Application.ScreenUpdating = False 'Your code Application.ScreenUpdating = True However, the best way of avoiding the screen noise is to rewrite your code to remove selections, which are rarely necessary and are usually inefficient. --- Regards, Norman "MicroMain" wrote in message ups.com... I'm a Macro NOVICE. i've recorded a macro which clears out cells, then copies a portion from another screen, and then does some more manipulations. I'm sure there is a command to supress the everchanging display as the macro executes, but I don't know how to find it. I have no manuals, and I have no help files installed on my pc. |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Supress display of multiple steps in Macro
Worked Perfectly.
Thanks |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| display calculation steps - not final answer | Excel Worksheet Functions | |||
| Need to supress display of FALSE in a cell | New Users to Excel | |||
| steps needed for freezing headers when using multiple pages | Excel Discussion (Misc queries) | |||
| steps to display .wmf ? | Excel Discussion (Misc queries) | |||
| Steps from Macro recorder for Pivot table will not run as a Macro | Excel Programming | |||
Linear Mode
