Very new to this and could not find my anser by searching.

I have the same need, but with 2003. My catch is that I want to make the
change in a macro. See below:

With Worksheets("Clarence")
.Protect Password:="qsi", userinterfaceonly:=True
.EnableOutlining = True
.EnableAutoFilter = True
End With

What is the setting for inserting and deleting rows in a macro like this?
Must be something like Enableoutlining.

"tiah" wrote:

with XP or 2003 you can choose exactly what you protect.

with 2000 or before, when you protect the sheet, you can't do anything.
so solution would be not to protect it to insert rows.