Thread: Excel Macro
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Norman Jones Norman Jones is offline
external usenet poster
 
Posts: 5,302
Default 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