Yes..the data I am using is in Sheet2 and the dataform is operating OK
--
ypukpete


"FSt1" wrote:

do you have data on sheet2? if not the macro will crash at .showdataform.

regards
FSt1

"ypukpete" wrote:

I wish to auto open excel's built in dataform and if possible hide the
worksheet it relates to.
I have tried Dave Peterson's...
Sub Auto_Open
Set wks = Worksheets("Sheet2")
With wks
Application.DisplayAlerts = False
.ShowDataForm
Application.DisplayAlerts = True
End With
End Sub

But had no success, the code breaks at .ShowDataForm
I would like to show the dataform and hide worksheet2 if possible
I am using excel 2000
Thanks in advance for your help with this.

--
ypukpete