Always open Excel file with Userform

I want to load the Userform first when ever I open a particular Excel file
which is saved with that specific Userform? Pls Help
Santhosh
Kuwait

Hi,
Load the form from a Workbook_Open event. This is found in the
ThisWorkbook class module....

Private Sub Workbook_Open()
Load UserForm1
UserForm1.Show
End Sub

Hth,
OJ

Thankyou So much

"OJ" wrote:

> Hi,
> Load the form from a Workbook_Open event. This is found in the
> ThisWorkbook class module....
>
> Private Sub Workbook_Open()
> Load UserForm1
> UserForm1.Show
> End Sub
>
> Hth,
> OJ
>
>