When you open an Excel worksheet, how do you make
instantly go to a user form?

You could have the worksheet activate event open the form.

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)

"Scott" wrote in message
...
When you open an Excel worksheet, how do you make
instantly go to a user form?

Thanks for the help
-----Original Message-----
You could have the worksheet activate event open the
form.

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)

"Scott" wrote in message
...
When you open an Excel worksheet, how do you make
instantly go to a user form?


.

If by sheet you mean workbook, then go into the VBE and in the project
explorer, under the project select ThisWorkbook. double click on it to
display the thisworkbook module. In the left dropdown select Workbook and
in the right dropdown select open (at the top of the module)

This will put in the declaration for the workbook_Open event. Put your code
to display the userform there

Private Sub Workbook_Open()
Userform1.Show
End Sub

Chip Pearson's page on Events:

http://www.cpearson.com/excel/events.htm


--
Regards,
Tom Ogilvy

"Scott" wrote in message
...
When you open an Excel worksheet, how do you make
instantly go to a user form?

Thanks for the help!!
-----Original Message-----
If by sheet you mean workbook, then go into the VBE and
in the project
explorer, under the project select ThisWorkbook. double
click on it to
display the thisworkbook module. In the left dropdown
select Workbook and
in the right dropdown select open (at the top of the
module)

This will put in the declaration for the workbook_Open
event. Put your code
to display the userform there

Private Sub Workbook_Open()
Userform1.Show
End Sub

Chip Pearson's page on Events:

http://www.cpearson.com/excel/events.htm


--
Regards,
Tom Ogilvy

"Scott" wrote in message
...
When you open an Excel worksheet, how do you make
instantly go to a user form?


.