open excel file into a form

  • Thread starter Thread starter Rick Sanderson
  • Start date Start date
R

Rick Sanderson

Hi,
another simple one i suspect,
when i open an excel file i want my form to open automatically.

thanks
Rick
 
Your form is a userform?

In a general module:

option Explicit
sub auto_Open()
userform1.show
end sub

(Or you could use the workbook_open event under ThisWorkbook.)
 
Back
Top