View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Bob Phillips[_3_] Bob Phillips[_3_] is offline
external usenet poster
 
Posts: 2,420
Default Block display during Macro

Application.ScreenUpdating = False

'your code

Application.ScreenUpdating = True

--
__________________________________
HTH

Bob

"Juan García" wrote in message
...
Hello,
I execute a macro that go across the sheet and insert and copy a lot of
rows and formats I would like the user doesn´t see the process, only the
results. Is possible 'lock' visual effects during the macro execution.
Thanks.-