How to hide all the actions while a macro is running

  • Thread starter Thread starter milo
  • Start date Start date
M

milo

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

Thanks,
milo
 
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
 
Use this line of code at the start of the macro and it
stops all the actionfrom appearing on the screen.

ScreenUpdating = False
 
Back
Top