Block display during Macro

[Juan García]

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.-

 

[Bob Phillips]

Application.ScreenUpdating = False

'your code

Application.ScreenUpdating = True

 

[Juan García]

Thanks...

Application.ScreenUpdating = False

'your code

Application.ScreenUpdating = True

--
__________________________________
HTH

Bob