The code makes excel invisible for 10 seconds and then excel will get visible again.
’Makes the excel invisible.
Application.Visible = False
’In order to be able to get back to excel there is a waiting time for 10 seconds then the application will be visible again.
Application.Wait Now + TimeValue("00:00:10")
’Makes the excel visible again.
Application.Visible = True
End Sub
Explanation
The code makes excel invisible for 10 seconds, this might be useful in some situations, and then excel will get visible again. The entire program will be invisible thus make sure to make excel visible again because otherwise you will not be able to change this setting back without terminating the program in other ways.Code
Public Sub HideExcelMakeExcelInvisible()’Makes the excel invisible.
Application.Visible = False
’In order to be able to get back to excel there is a waiting time for 10 seconds then the application will be visible again.
Application.Wait Now + TimeValue("00:00:10")
’Makes the excel visible again.
Application.Visible = True
End Sub
No comments:
Post a Comment