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

Answering Pop questions when macro is running 2
display message while code is running 5
Macro to Copy hidden worksheet to new worksheet 4
Hide Formula bar while workbook is open 1
Different Results running the same macro?? 5
User Form Flickering 4
Message while macro is executing 3
Excel TWO Instances of Excel One watching Other 3

Top