Thread: Excel Macro
View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.programming
Victor & Toni Jo Friedmann Victor & Toni Jo Friedmann is offline
external usenet poster
 
Posts: 3
Default 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