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

Thanks,
Discover

--
Discover
-----------------------------------------------------------------------
Discovery's Profile: http://www.excelforum.com/member.php...fo&userid=2585
View this thread: http://www.excelforum.com/showthread.php?threadid=39370

In your workbook autoopen (or open event), show your userform.

--
Regards,
Tom Ogilvy

"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

On Sun, 7 Aug 2005 15:30:49 -0500, Discovery
wrote:


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


AFAIAA there has to be at least one sheet open and visible.

Rgds

__
Richard Buttrey
Grappenhall, Cheshire, UK
__________________________

I think the only way is to make particular workbook hidden (Window -
Hide) and insert into the module code similar to this:


Sub auto_open()
UserForm1.Show (1)
End Sub

Save it then and it should work.

mlhos


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

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

Private Sub Workbook_Open()
ActiveWindow.Visible = False
Userform1.Show
Windows(ThisWorkbook.Name).Visible = True
End Sub

'This is workbook event code.
'To input this code, right click on the Excel icon on the worksheet
'(or next to the File menu if you maximise your workbooks),
'select View Code from the menu, and paste the code

The workbook will flash briefly though.

--

HTH

RP
(remove nothere from the email address if mailing direct)


"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

Thank you for all your help everyone.

Bob Phillips, your code worked the first time, but when I opened it u
the second time, it said, "Run-time error '91': Object variable o
With block variable not set" - any ideas what's happened?

Thanks,
Discover

--
Discover
-----------------------------------------------------------------------
Discovery's Profile: http://www.excelforum.com/member.php...fo&userid=2585
View this thread: http://www.excelforum.com/showthread.php?threadid=39370