You should simply use password protection, but if you want to avoid the
manual effort of disabling and then re-enabling protection, you can use the
workbook open event macro:

Private Sub Workbook_Open()
If Environ("username") = "James" Then
' clear desired workbook and worksheet protections
Else
' set desired workbook and worksheet protections
End If
End Sub

or something similar
--
Gary''s Student - gsnu200825


"brown1965" wrote:

I am setting up a workbook and I am wondering if you can put protection on it
to prevent some users from inserting / deleting rows but allow other users
(people that will be doing maintenance on the file) to delete / insert rows
without having to remove the protection every time?