Hide excel, display userform only
 

Hi everyone.
Is it possible that when you load a workbook, it hides everything
except for userform1?

The thing is it looks a bit silly with userform 1 loading up and having
excel with the toolbars etc behind it. One thing i did do was make it so
before the userform loaded, it shrunk excel to the smallest size
possible and positioned it behind the userform. But when you use
userform1 and click on "go" it runs a macro which hides userform1, then
has to maximize the window and then display sheet2 which also looks a
bit silly.

Any ideas?

Thanks,
Andy


--
carlito_1985
------------------------------------------------------------------------
carlito_1985's Profile: http://www.excelforum.com/member.php...o&userid=21390
View this thread: http://www.excelforum.com/showthread...hreadid=469761

Hide excel, display userform only
 

Andy,

Add this code to your userform


Private Sub UserForm_Activate()
Application.Visible = False
End Sub

Private Sub UserForm_QueryClose(Cancel As Integer, CloseMode As Integer)
Application.Visible = True
End Sub



--
HTH

Bob Phillips

"carlito_1985"
wrote in message
news:carlito_1985.1vqpmd_1127358310.6544@excelforu m-nospam.com...

Hi everyone.
Is it possible that when you load a workbook, it hides everything
except for userform1?

The thing is it looks a bit silly with userform 1 loading up and having
excel with the toolbars etc behind it. One thing i did do was make it so
before the userform loaded, it shrunk excel to the smallest size
possible and positioned it behind the userform. But when you use
userform1 and click on "go" it runs a macro which hides userform1, then
has to maximize the window and then display sheet2 which also looks a
bit silly.

Any ideas?

Thanks,
Andy


--
carlito_1985
------------------------------------------------------------------------
carlito_1985's Profile:
http://www.excelforum.com/member.php...o&userid=21390
View this thread: http://www.excelforum.com/showthread...hreadid=469761