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...
 
Top