Open Anther Excel Sheet While Excel Form Is Open

[mark.mba]

I have a form that opens and hides the application to hide the excel sheets so all the user sees is my form. I need the user to be able to open other spreed sheets while my form is open. I can't get another excel to open like normal but it is hid behind my form.

What do you guys think?

Mark

 

[Bill Rockenbach]

Can you post the code you are using to "hide" the application?

 

[mark.mba]

Application.visible = false

 

[HalfAce]

Mark,
You should be able to just change the Application.Visible property to True with code from your userform. I assume you're already showing that form non-modally in order to hide the application while it's showing, right?