David Montoya
New Member
- Joined
- Apr 25, 2018
- Messages
- 49
Using the following macro in Excel 2010 work perfect; however, when it runs under Excel 2016 it creates a ghost Excel page:
Is there a way to avoid the ghost page from appearing? I have tried the wait time before, and after the "More macros, and it does not make any difference. If I do not hide the application, Excel does not create the ghost page, but it leaves it the risk to crash the macro, if the user tries to do anything while the macros is running.
Thank you!
Code:
Application.Visible = False
'More macros
Application.Wait Now + TimeValue("00:00:05")
Application.Visible = True
Is there a way to avoid the ghost page from appearing? I have tried the wait time before, and after the "More macros, and it does not make any difference. If I do not hide the application, Excel does not create the ghost page, but it leaves it the risk to crash the macro, if the user tries to do anything while the macros is running.
Thank you!