Make Excel Invisible and Hide Excel

The code makes excel invisible for 10 seconds and then excel will get visible again.

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.

The entire VBA Excel program is available for downloading at the bottom of this web page, enjoy!
 

 

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

 

 

 

Download excel file! Make_Excel_Invisible_And_Hide_Excel.xls
 
Comments (3)
Macro
3 Wednesday, 01 June 2011 00:51
Saravanan
Superp!!!
to hide only workbook
2 Friday, 21 January 2011 13:22
User1
Application.visible = flase will hide the complete appltion,so all the open workbooks loose the visibility,can any help with the code to hide only one workbook not using Activewindow.hide
:)
1 Saturday, 18 December 2010 06:17
hanz
bgus bgt, low bisa skalian dgn gambarnya donk!

Add your comment

Your name:
Subject:
Comment:
yvComment v.CommentVersion