Make Excel Invisible and Hide Excel




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

bgus bgt, low bisa skalian dgn gambarnya donk!

Comment made by: hanz , 2010-12-18 06:17:26


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

Comment made by: User1 , 2011-01-21 13:22:19


Superp!!!

Comment made by: Saravanan , 2011-06-01 00:51:09


Thanks for giving hide workbook

Comment made by: Anandababu , 2012-11-07 17:14:29


Cool!

Comment made by: Junior , 2013-05-03 20:28:47


Just Superb

Comment made by: Biswa , 2016-01-08 06:20:19


PUTOS!!!

Comment made by: me la pelan , 2016-02-20 21:58:27


Write Comment:

Comment:

two + 3 minus 1=


Your name: