Thread: Always open Excel file with Userform
View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.programming
Santhosh Mani Santhosh Mani is offline
external usenet poster
  
Posts: 7
Default 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


Reply With QuoteReply With Quote