Excel VBA : windows(thisworkbook.name).visible = false

[Tanushri_Kothari]

Hi, I have designed a userform in Excel 2007. I am using below code to hide only current workbook and to display userform1. It functions pretty well but the problem is, those workbooks which are already open on my desktop, those display on windows taskbar but if I click on them, nothing happens, only userform shows up. How can I just hide current workbook and allow to work on other pre-opened workbooks?

Private Sub Workbook_Open()
Windows(ThisWorkbook.Name).Visible = False
UserForm1.Show
End Sub

 

[Somendra Misra]

Hi Tanushri,

Here is one possibility try below line in your code:

UserForm1.Show vbModeless

instead of Userform1.Show

Regards,

 

[Tanushri_Kothari]

Hi Tanushri,

Here is one possibility try below line in your code:

UserForm1.Show vbModeless

instead of Userform1.Show

Regards,

Thanks Somendra, it worked perfectly