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

Application.ScreenUpdating = False

'your code

Application.ScreenUpdating = True

--
__________________________________
HTH

Bob

"Juan García" <(E-Mail Removed)> wrote in message
news:(E-Mail Removed)...
> 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.-
>

Thanks...
"Bob Phillips" <(E-Mail Removed)> escribió en el mensaje
news:(E-Mail Removed)...
> Application.ScreenUpdating = False
>
> 'your code
>
> Application.ScreenUpdating = True
>
> --
> __________________________________
> HTH
>
> Bob
>
> "Juan García" <(E-Mail Removed)> wrote in message
> news:(E-Mail Removed)...
>> 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.-
>>
>
>