Make Excel Invisible and Hide Excel
The code makes excel invisible for 10 seconds and then excel will get visible again.
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!
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
Download excel file! Make_Excel_Invisible_And_Hide_Excel.xls
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
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
Comment made by: Junior , 2013-05-03 20:28:47
Comment made by: Biswa , 2016-01-08 06:20:19
Comment made by: me la pelan , 2016-02-20 21:58:27
no longer work in Excel 2013 or Excel 2016
Comment made by: sunrise , 2019-03-23 11:18:09