open excel file into a form

R

Rick Sanderson

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

thanks
Rick
 
D

Dave Peterson

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.)
 
Top