Data Form question

  • Thread starter Thread starter WylieC
  • Start date Start date
W

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.
 
Option Explicit
Sub auto_open()
With Worksheets("sheet1")
.Select
Application.DisplayAlerts = False
.ShowDataForm
Application.DisplayAlerts = True
End With
End Sub

might be ok.
 
Back
Top