You could add a button to the worksheet and link it to the following macro.

Sub Macro1()

ActiveSheet.Unprotect
ActiveSheet.ShowDataForm
ActiveSheet.Protect

End Sub

This will unprotect the worksheet and show the form. When you close the form,
your worksheet will be locked again.

Make sure you unprotect the button though so you can still click it when the
worksheet is locked.

Jamo

jojoba wrote:
The inbuilt data form with New, Delete, Restore, Find Prev, Find Next,
Criteria, Close options

Are you using the inbuilt data form, or have you made your own?

[quoted text clipped - 7 lines]

Please help its urgent

--
Message posted via http://www.officekb.com