open excel file into a form

[Rick Sanderson]

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

thanks
Rick

 

[Dave Peterson]

Your form is a userform?

In a general module:

option Explicit
sub autpen()
userform1.show
end sub

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