Hide Excel and only show userform

[tony.reynolds]

Is it possible to Hide excel and only show the userform on the desktop

I realise that excel would still show on the taskbar.

My userform has all the functions needed to edit the sheets

 

[Tom Urtis]

Is it possible to Hide excel and only show the userform on the desktop

I realise that excel would still show on the taskbar.

Yes it is possible

and

contrary to your supposition, Excel does not need to show on the task bar.

You can accomplish this by putting this code in your userform's module:

Private Sub UserForm_Initialize()
Application.Visible = False
End Sub
 
Private Sub UserForm_Terminate()
Application.Visible = True
End Sub

 

[tony.reynolds]

Hey Thats cool

I also found i can make the userform show in task bar and minimise and maxmise buttons!

Here:

http://www.mrexcel.com/forum/showthread.php?t=392886

Cheers