ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Don`t show when running (https://www.excelbanter.com/excel-programming/369085-don%60t-show-when-running.html)

peteriks

Don`t show when running
 

Hi

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

--
peterik
-----------------------------------------------------------------------
peteriks's Profile: http://www.excelforum.com/member.php...fo&userid=3701
View this thread: http://www.excelforum.com/showthread.php?threadid=56733


Trevor Shuttleworth

Don`t show when running
 
Application.ScreenUpdating = False
' your code
Application.ScreenUpdating = True

Regards

Trevor


"peteriks" wrote in
message ...

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[_2_]

Don`t show when running
 

Thanks Trevor :)


--
peteriks
------------------------------------------------------------------------
peteriks's Profile: http://www.excelforum.com/member.php...o&userid=37011
View this thread: http://www.excelforum.com/showthread...hreadid=567330



All times are GMT +1. The time now is 02:52 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com