View Single Post
  #1   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!

"Dave Peterson" wrote:

application.screenupdating = false
'lots of code here
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


--

Dave Peterson
.