Thread: Hide Screens While Macro is Running
View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.programming
crmulle crmulle is offline
external usenet poster
  
Posts: 11
Default Hide Screens While Macro is Running
Thank you!

"Tim" wrote:

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

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


"crmulle" wrote:

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
Reply With QuoteReply With Quote