I need a UserForm to Auto Start

[Debi]

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?

 

[Bob Phillips]

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]

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)




.