So the current code im working with will hide all workbooks and load the userform. Im wanting it to only hide the workbook the userform is connected to and if possible leave the taskbar icon visible as the userform is easily lost behind other documents.
Iv had a look around and was able to find the code below which gets me a little closer (kind of gives me a taskbar icon) however this minimizes the userform until opened via taskbar and if selected again makes the workbook visiable.
Any suggestions would be great. Thanks!
VBA Code:
Sub Button1_Click()
Application.Visible = False
Userform1.Show
End Sub
Iv had a look around and was able to find the code below which gets me a little closer (kind of gives me a taskbar icon) however this minimizes the userform until opened via taskbar and if selected again makes the workbook visiable.
VBA Code:
Sub Button1_Click()
Application.Visible = False
Application.Windowstate = xlMinimized
Application.Visible = True
End Sub
Any suggestions would be great. Thanks!