How to hide all the actions while a macro is running
 

Is there a way or a code to hide all the actions while a
macro is running?

Thanks,
milo

How to hide all the actions while a macro is running
 

application.ScreenUpdating=False


-----Original Message-----
Is there a way or a code to hide all the actions while a
macro is running?

Thanks,
milo
.

How to hide all the actions while a macro is running
 

Don't forget to change that to true at the end of the
macro

Sub MyMacro()
application.ScreenUpdating=False
'do your thing
application.ScreenUpdating=True
End Sub


Regards,

Peo Sjoblom



-----Original Message-----
application.ScreenUpdating=False


-----Original Message-----
Is there a way or a code to hide all the actions while
a
macro is running?

Thanks,
milo
.

.

How to hide all the actions while a macro is running
 

Use this line of code at the start of the macro and it
stops all the actionfrom appearing on the screen.

ScreenUpdating = False

-----Original Message-----
Is there a way or a code to hide all the actions while a
macro is running?

Thanks,
milo
.