Hide Screens While Macro is Running

  • Thread starter Thread starter crmulle
  • Start date Start date
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
 
application.screenupdating = false
'lots of code here
application.screenupdating = true
 
Put this line at the beginning of the macro:
Application.ScreenUpdating = False

And this one at the end:
Application.ScreenUpdating = True
 
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...
 
Back
Top