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
Very nice information .. good work
what is m2m
great info.....
vacation homes near disney
Post a Comment