ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Hide all windows while macro is running (https://www.excelbanter.com/excel-programming/380103-re-hide-all-windows-while-macro-running.html)

John Bundy

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?





All times are GMT +1. The time now is 08:33 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com