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
|