Debi,

Excel uses Auto_Open

Sub Auto_Open()
MyForm.Show
End Sub


--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)

"Debi" wrote in message
...
This is the first time I have used VBA in Excel and I'm
having this problem.

In Word, I can have a userform auto load when a template
is opened, but I am having trouble getting this done in
Excel. It seems the same code does not work for Excel...

I write this in the code Modulae for This Document.

Sub AutoNew()
MyForm.Show
End Sub

Is there similar code for Excel?