How to protect some cells, but able to insert rows elsewhere?

[Ingeniero1]

I need to protect cells A1:C6, but be able to modify B1, and need to
insert and delete rows below row 6.

I selected the entire worksheet, unlocked the cells, then locked cells
A1:C6, and unlocked B1. Thi worked fine for cell contents - when I
protect the sheet, the cells are protected as I wanted, but I cannot
insert or delete rows anywhere.

Is there a way to accomplish the cell content protection as I did
above, but be able to also insert and delete rows?

Thanks!

Alex

 

[EdMac]

in later versions of Excel this is possible. When you choose Tool>
Protect select the actions you want users to be able to perform before
you set the password.

Ed

 

[Ingeniero1]

Ed,
"-...in later versions of Excel ...-"
How recent version? The one I am using here is Excel 2000, and the
options for protecting the sheet are for Contents, Objects, and
Scenarios. These do not affect the ability to delete or insert rows;
that is, regardless of which I check, I cannot insert or delete rows
once the sheet is protected.

Thanks

Alex

 

[EdMac]

I'm using 2003, so I guess it came in somewhere after 2000 - sorry
can't help - it may be possible using vba.

E

 

[Infinity]

Excel 2000 does not have that function . If I am not mistaken it
started from Excel 2002.

Rgds.

 

[Ingeniero1]

OK, I appreciate that.

Now to the challenge of figuring out an alternate way of doing it -
hmmm....

If anyone can figure out how to accomplish this 'long hand', please
let us know.

Then again, maybe I can convince the IT department to upgrade me to
2003.

Thanks all the same!

Alex

 

[EdMac]

I guess they could only do as you can now - the features in
spreadsheet created by a later version are not avaialable to users o
an earlier version that does not have them.

e