Solved: Minimizing Excel

[wildpianist]

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

[Charlize]

[VBA]application.visible = False[/VBA]but you better make sure that this setting is resetted to true on exit or when an error occurs.

[wildpianist]

where do i put the code to reset the window on error and what would that code be?

[wildpianist]

well blow me down....... it works

[wildpianist]

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]

Windows does that as amatter of course.

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

[wildpianist]

Of course, how silly!