vba excel - hiding of an Application and closing different workbooks

[terriertrip]

Can someone please help me with this? I've tried to test this and can't seem to isolate the problem. The
Workbook1 application window is hidden upon opening (what I mean by this is that the entire Excel application window is hidden from view) using:

Application.Visible = False
UserForm1.Show

If I open other Excel applications, and close any of them using the big red x, it closes the application holding UserForm1.

So I tried:

ActiveWindow.Visible = False
UserForm1.Show

This creates a different problem. The Excel application window is still visible, but the Workbook1 window becomes hidden. VBA throws an error activating UserForm1 saying that the global focus cannot be set.

I've tried
Windows(ThisWorkbook.Name).Visible = False

This still leaves the application window visible (Workbook hidden) and throws an error upon UserForm1.Show
I know I can probably use something like

Please Login or Register  to view this content.

That still wouldn't address the issue of hiding the application window though when UserForm1 is open. Is there a sub to keep the Workbook1 from closing if other workbooks are commanded to close?

[6StringJazzer]

Closed at the request of terriertrip to open in Commercial Services.