View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
John Bundy John Bundy is offline
external usenet poster
 
Posts: 93
Default Hide all windows while macro is running

Use Application.Visible=False after opening each of them.

--
--
-John
Please rate when your question is answered to help us and others know what
is helpful.

"Freddy" wrote in message
...
My current module opens multiple workbooks, saves them, prints them, then
closes them. My intention is to have all this happen but not see it
happening
in the background. I only want to display a status bar message stating
that
the macro is running (I have the code to display a status bar message).
Any
suggestions?