Don`t show when running

[peteriks]

Hi

When running a macro, there is no need to display the steps macro is executing, how I can switch it off
Thanks
Peter

[Trevor Shuttleworth]

Application.ScreenUpdating = False
' your code
Application.ScreenUpdating = True

Regards

Trevor


"peteriks" <[email protected]> wrote in
message news:[email protected]...
>
> Hi
>
> When running a macro, there is no need to display the steps macro is
> executing, how I can switch it off
> Thanks
> Peter
>
>
> --
> peteriks
> ------------------------------------------------------------------------
> peteriks's Profile:
> http://www.excelforum.com/member.php...o&userid=37011
> View this thread: http://www.excelforum.com/showthread...hreadid=567330
>

[peteriks]

Thanks Trevor