Thread: Auto Open
View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.programming
Vasant Nanavati Vasant Nanavati is offline
external usenet poster
 
Posts: 1,080
Default Auto Open

Sub Workbook_Open()
UserForm1.Show
Application.Visible = False
End Sub

Be sure to reset the Visible property of the Application object to True when
you dismiss the UserForm.

--

Vasant




"Discovery" wrote in
message ...

Is it possible to have an auto open for a user form? I want my user
form to open when I open my workbook, without the worksheets showing.
Is that possible?

Thanks,
Discovery


--
Discovery
------------------------------------------------------------------------
Discovery's Profile:
http://www.excelforum.com/member.php...o&userid=25859
View this thread: http://www.excelforum.com/showthread...hreadid=393707