i need to alter this macro so that when it opens up the forms screen it should choose 'Criteria'. Any Ideas?
Sub EDITORDELETE_MEMDATA()
Sheets("Member Database").Select
ActiveSheet.Unprotect
ActiveSheet.ShowDataForm
ActiveSheet.Protect DrawingObjects:=True, Contents:=True, Scenarios:=True
End Sub
Sub EDITORDELETE_MEMDATA()
Sheets("Member Database").Select
ActiveSheet.Unprotect
ActiveSheet.ShowDataForm
ActiveSheet.Protect DrawingObjects:=True, Contents:=True, Scenarios:=True
End Sub