This is one of those things that you can solve by recording a macro:

I got this line:

ActiveSheet.Protect DrawingObjects:=True, Contents:=True, Scenarios:=True

xl didn't record the actual password. But I could look at help and see that I
need something like:

ActiveSheet.Protect DrawingObjects:=True, _
Contents:=True, Scenarios:=True, password:="hi"



"shirley <" wrote:

i want to protect my worksheet with password after a new row has been
added in. how do i go about doing it? i am unsure what object or
methods to use.

---
Message posted from http://www.ExcelForum.com/

--

Dave Peterson