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?

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?

Thank you so much!!
-----Original Message-----
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?


.