VBA code to create separate Excel instance and hide application

[PatHat]

Hi All,

I'm looking for a way to open my workbook in a separate instance of Excel and then hide the application and show only a userform called Client_Information_UF.

After searching around I found this bit of code to create a separate instance of Excel, but if I change xlApp.Visible = True to xlApp.Visible = False, the application and workbook still shows behind the userform when opening. Not sure why, i thought the False statement would hide the application?

Private Sub Workbook_Open()

Dim xlApp As Excel.Application
Set xlApp = New Excel.Application
xlApp.Visible = True
Set xlApp = Nothing
Client_Information_UF.Show

End Sub


I need the application of this particular instance of Excel to hide only. If i was to use for e.g. a shared instance of Excel and use code like Application.Visible = False somewhere in my Sub, then it hides any other workbooks that the user may have open when I open this workbook.

Hope my question is clear and forgive me if its a really obvious solution. I'm really new to VB.

Thanks in advance

Patrick

 

[RoryA]

Welcome to the forum.

Please take a minute to read the forum rules on cross-posting, then add links here to your posts in other forums. Thanks.

 

[PatHat]

Oops sorry Rory, my apologies. Can I delete this thread then?

 

[RoryA]

You don't have to. Just add a link to your other thread so that people can see what's already been suggested. You may get additional ideas here.

 

[PatHat]

https://www.excelforum.com/excel-pr...nstance-and-hide-application.html#post4992432

Link to my other thread with same query