Logo 
Search:

MS Office Answers

Ask Question   UnAnswered
Home » Forum » MS Office       RSS Feeds
  Question Asked By: Waldemar Fischer   on Oct 27 In MS Office Category.

  
Question Answered By: Jawwad Akram   on Oct 27

You can use Application.Visible = False to hide Excel. Here is an example, in
the UserForm_Activate event of the form:

Private Sub UserForm_Activate()
'Hide Excel when this form  is activated
Application.Visible = False
End Sub

Use Application.Visible = True to make Excel visible again. Here is an example,
in the code attached to a "Close form" button on a userform:

Private Sub cmdExit_Click()
Unload Me
Application.Visible = True
End Sub

Share: 

 

This Question has 1 more answer(s). View Complete Question Thread

 
Didn't find what you were looking for? Find more on Is there way to minimize the excel window? Or get search suggestion and latest updates.


Tagged: