ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   hide (https://www.excelbanter.com/excel-programming/303376-hide.html)

No Name

hide
 
Is it possible to hide Excel while a vba macro is running
and then have it reopen when the macro is finished. If so,
what is the code I should use at the beginning and end of
the macro.

William[_2_]

hide
 
Hi

Sub MyMacro()
Application.Visible=False
'Code here
Application.Visible=True

--
XL2002
Regards

William



wrote in message
...
| Is it possible to hide Excel while a vba macro is running
| and then have it reopen when the macro is finished. If so,
| what is the code I should use at the beginning and end of
| the macro.




All times are GMT +1. The time now is 04:14 PM.

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