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

Always open Excel file with Userform
 

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

Always open Excel file with Userform
 

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