VBA – Hide Excel (The Entire Application)

Hide Excel

There may occasionally arise a need to hide all of excel, a good time may be while displaying a splash screen, or possibly coding a security variation.

Put this in a module:

Public Sub HideMyExcel()

Application.Visible = False
Application.Wait Now + TimeValue("00:00:05")
Application.Visible = True

End Sub

Sidenote: I used a timer so we can see Excel again, don’t forget to set Visible=True at some point!