Data Form question
 

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.

Data Form question
 

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

might be ok.

WylieC wrote:

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