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


--
Leith Ross
------------------------------------------------------------------------
Leith Ross's Profile: http://www.excelforum.com/member.php...o&userid=18465
View this thread: http://www.excelforum.com/showthread...hreadid=503152

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

"Leith Ross" wrote:


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


--
Leith Ross
------------------------------------------------------------------------
Leith Ross's Profile: http://www.excelforum.com/member.php...o&userid=18465
View this thread: http://www.excelforum.com/showthread...hreadid=503152