PDA

View Full Version : Solved: Minimizing Excel



wildpianist
10-29-2007, 01:52 PM
Is there a way that when I press a button on Excel to Run a macro to open a UserForm

Is there a way to hide Excel and just show the UserForm, the problem I get is when I ask Excel to Minimise it also hides the UserForm.

I'm guessing it's not possible.

It's just I dont really want Excel showing so I can use the applications behind it. Bit more user friendlier lol

:rotlaugh:

Charlize
10-29-2007, 02:18 PM
application.visible = Falsebut you better make sure that this setting is resetted to true on exit or when an error occurs.

wildpianist
10-29-2007, 02:21 PM
where do i put the code to reset the window on error and what would that code be? :)

wildpianist
10-29-2007, 02:28 PM
well blow me down....... it works:ole:

wildpianist
10-29-2007, 02:39 PM
here's one for ya - is there a way to put an icon on the taskbar so that if I open IE or something I can get back to it easily without having to minimise everything else?

Bob Phillips
10-29-2007, 02:42 PM
Windows does that as amatter of course.

You can also use Alt-Tab to tab through apps.

wildpianist
10-29-2007, 03:21 PM
Of course, how silly!