Hide Screens While Macro is Running

C

crmulle

I don't want the user to see the various spreadsheets and items that pop up
during a macro. How can I make this disappear while the macro is running?

Thank you,
crmulle
 
D

Dave Peterson

application.screenupdating = false
'lots of code here
application.screenupdating = true
 
T

Tim

Put this line at the beginning of the macro:
Application.ScreenUpdating = False

And this one at the end:
Application.ScreenUpdating = True
 
C

crmulle

Thank you!

Tim said:
Put this line at the beginning of the macro:
Application.ScreenUpdating = False

And this one at the end:
Application.ScreenUpdating = True
Click to expand...
 

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
Menu Macro Not Executing - Need Help 1
Dumb question alert! What program to use? 0
Can't save my Office documents (after computer rebuild and reauthorization) 0
Menu driven PowerPoint presentations 0
Macro to Select text from a point given to a specific word 2
Template with fields and premade texts.. 0
E-mails disapair from trash 0

Top