Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Excel Macro
How do I turn off the option that shows each and every cell in a spread
sheet as the macro progresses through its execution? In other words, I don't want the spread sheet to follow the computations until at the very end. This should speed up the execution of the macro. In Excel 4 the command was Echo(false), but I don't know what it is in Visual Basic. Thanks, Vic |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Excel Macro
Hi Vic,
Try Application.ScreenUpdating = False ' Your Code Application.ScreenUpdating = True --- Regards, Norman "Victor & Toni Jo Friedmann" wrote in message ... How do I turn off the option that shows each and every cell in a spread sheet as the macro progresses through its execution? In other words, I don't want the spread sheet to follow the computations until at the very end. This should speed up the execution of the macro. In Excel 4 the command was Echo(false), but I don't know what it is in Visual Basic. Thanks, Vic |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Excel Macro
Application.ScreenUpdating = False
In addition, if it is a long macro that does not require recalculation until the completion of the macro, it is sometimes useful to turn of automatic calculation at the beginning and restore it at the end: 'at the beginning Dim lCalculation as long lCalculation = Application.Calculation Application.Calculation = xlCalculationManual 'at the end Application.Calculation = lCalculation Bare in mind that if you break out of the macro before the end then calculation will be set to manual, and may require manually resetting to automatic. -- Return email address is not as DEEP as it appears "Victor & Toni Jo Friedmann" wrote in message ... How do I turn off the option that shows each and every cell in a spread sheet as the macro progresses through its execution? In other words, I don't want the spread sheet to follow the computations until at the very end. This should speed up the execution of the macro. In Excel 4 the command was Echo(false), but I don't know what it is in Visual Basic. Thanks, Vic |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
Excel Macro
Thanks, it worked like a charm.
Vic Norman Jones wrote in message ... Hi Vic, Try Application.ScreenUpdating = False ' Your Code Application.ScreenUpdating = True --- Regards, Norman "Victor & Toni Jo Friedmann" wrote in message ... How do I turn off the option that shows each and every cell in a spread sheet as the macro progresses through its execution? In other words, I don't want the spread sheet to follow the computations until at the very end. This should speed up the execution of the macro. In Excel 4 the command was Echo(false), but I don't know what it is in Visual Basic. Thanks, Vic |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Macro Help Needed - Excel 2007 - Print Macro with Auto Sort | Excel Worksheet Functions | |||
My excel macro recorder no longer shows up when recording macro | Excel Discussion (Misc queries) | |||
My excel macro recorder no longer shows up when recording macro | Excel Discussion (Misc queries) | |||
Excel Macro Issue Trying to autorun Macro Upon Opening Worksheet | Excel Programming |