让Excel隐形和隐藏Excel中

该代码为10秒,使无形的Excel,然后Excel将得到再次可见。

解释

该代码为10秒,使无形的擅长,这可能是有用的一些情况,然后Excel就会再次可见。

整个VBA Excel程序是可在本网页的底部,下载欣赏!

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

 

 

 

下载Excel文件!Make_Excel_Invisible_And_Hide_Excel.xls

 

Add your comment

Your name:
Subject:
Comment: