Minimising Excel

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Is there a way to have excel minimised while a form is up on the sceen.
 
Hello Jason,

If you simply want to get Excel out the way and easy way to this is
have the form hide Excel when it starts and unhide Excel when it
closes.

To Hide Excel:
Application.Visible = False

To Restore Excel:
Application.Visible = True

You can do it the way you want, but because the UserForm is modal it
will be minimized along with Excel. This problem can be worked around
as well. The code uses a lot of API calls and I am not sure you want to
include all this extra code in your project. That's why I made the above
suggestion.

Sincerely,
Leith Ross
 
Hey Leith,

That Code that has all the API calls looks to be the one I'm after so if you
can get that code to me that would be greatly appreciated.

Thanks

Jason Zischke
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Maximise Event 2
Which colour printer to buy? 2
Minimise/Restore 2
games minimising to desktop 3
Minimise worksheets 6
Delay in file opening in excel 2007 3
Running macros when multiple Excels are open 1
Minimise Workbook 9

Back
Top