Place the code in the WORKBOOK OPEN event

Private Sub Workbook_Open()
ActiveSheet.ShowDataForm
End Sub

Corey....
"dd" <dd.dd wrote in message
...
Is there a way to have the DataForm command activate when the file is
opened
? I tried the following worksheet event, but nothing happens:

Private Sub Worksheet_Activate()
ActiveSheet.ShowDataForm
End Sub

Also, is there a way to attach validation lists to the form's textboxes so
that users can select the required data?

Regards
D Dawson