Hide userform's workbook and leave other excel workbooks un-hidden

[MBaker25]

Hello all,


I created a Userform in Excel 2013 -


I want only the Userform to be visible and it's workbook hidden. The code I'm using does show the Userform, but also hides all open workbooks in excel leaving only the userform visible. What code do I use to only hide the Userform's workbook and leave other open workbooks un-hidden?

The code below is as far as I got -

Private Sub Workbook_Open()

Application.Visible = False
UserForm1.Show

End Sub

I am sure the "Application.Visible = False" is the problem, I tried "Thisworkbook.visible = False" but got an error message. Any suggestions??

 

[Alan_P]

Hi mBaker25,

Try it with

ThisWorkbook.Windows(1).Visible = False

Cheers,
Alan.