Data Form question

[WylieC]

I have a worksheet with the titles in the first row and
data below it that is basically an address book. I would
like to have the worksheet open with a data form ready to
use. How can I do this?
Thank you.

 

[Dave Peterson]

Option Explicit
Sub auto_open()
With Worksheets("sheet1")
.Select
Application.DisplayAlerts = False
.ShowDataForm
Application.DisplayAlerts = True
End With
End Sub

might be ok.