I want to protect the sheet and only allow user to delete rows. This possible?

[skitzz]

I want to protect the sheet and only allow user to delete rows. This possible? I built a user form and i haven't figured out how to create a delete button in the form. So the next best thing os to allow the user to delete that entire row/record. So I need it so that if users create a new record or update a record and want to delete the old one, they can do it in the database tab. Right now when a user creates a record it goes into a table in a separate tab (database table). I don't want the user to be able to delete/add or edit a cell because I have created pre-defined values /dropdowns in the form and they may type in the wrong value.

In the protect worksheet options it says 'Allow all users of this worksheet to:"

Then it lists several functions including "delete rows".

I just cant get it to work. Any thoughts?

 

[Worf]

See if this example is useful:

' UserForm module
Dim sh As Worksheet

Private Sub CommandButton1_Click()  ' code for delete button
sh.Unprotect "password"
sh.Cells(4, 1).EntireRow.Delete     ' delete a row
sh.Protect "password"
End Sub

Private Sub UserForm_Initialize()
Set sh = Sheets("Sheet1")
If sh.ProtectContents = False Then sh.Protect "password"
End Sub

 

[skitzz]

Thanks ill try it out. got pulled off of this assignment to work on something else.