| 2 comments ]

Excel-icon To make excel Invisible or Hide for few minutes or seconds might be useful in some situations. The code makes excel invisible only for 10 seconds and after that excel will get visible again automatically.

So need to fist open a new Excel worksheet.

Then open Microsoft Visual Basic Editor via pressing Alt+F11 key.

then paste the following code and save.

Public Sub HideorInvisibleExcel()

'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

'visit: http://triple9.co.vu
End Sub




You can change “TimeValue” as you wish. and you can also assign a shortcut key for your Macro from View –> Macro –> View Macro –> Options



tags: excel vba codes free, excel vba fun, vba tricks, make excel invisible, free excel vba codes,Microsoft excel macro codes, Fun excel macro code 


2 comments

m2mdaily said... @ November 19, 2011 at 12:54 AM

Very nice information .. good work
what is m2m

Yvonne Kirby said... @ November 19, 2011 at 2:42 AM

great info.....

vacation homes near disney

Post a Comment

 
Related Posts Plugin for WordPress, Blogger...