How to hide all the actions while a macro is running

M

milo

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

Thanks,
milo
 
P

Peo Sjoblom

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
 
T

Tim

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

ScreenUpdating = False
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Need Help with Macro Security 1
Improving Macro That Keeps First Letter 0
While working with word 2010, closed itself! 0
AppleScript - How do I select a text ? 1
Visio shape text disappears upon copy paste 1
Macro to hide cols 2
macro hide 2
Macro to Select text from a point given to a specific word 2

Top