I've protected a column of cells in my worksheet, but I've also set it so
that rows can be added and deleted.

But if I try to insert a row and copy the data from an existing row, I get
an error since I'm trying to 'update' the protected cell.

A similar problem happens when I try to delete (I'm assuming because one of
cells is protected and it thinks I'm trying to change it.)

What's the purpose of allowing adding and deleting rows to protected sheets
if it doesn't work when a row has a locked column.? bIs there any way around
this?

Thanks

Just as a point of order, worksheets are protected or unprotected and cells
are locked or unlocked.

It seems to me that Excel is doing what it has to. When you insert a row in
a protected sheet the new row inherits the format of the above row,
including the locked state of each cell. So the cells below unlocked cells
are unlocked and the cells below locked cells are locked. And of course
locked cells cannot be changed so you cannot copy into them. If you could
they wouldn't be locked, right?

The only way to do what you want is a macro I think. It would have to
unprotect the sheet, do the insert and copy, and then reset the sheet
protection. You'd have to give the user a way to fire the macro; a button
on sheet may be a good way.
--
Jim
"tee" wrote in message
...
| I've protected a column of cells in my worksheet, but I've also set it so
| that rows can be added and deleted.
|
| But if I try to insert a row and copy the data from an existing row, I get
| an error since I'm trying to 'update' the protected cell.
|
| A similar problem happens when I try to delete (I'm assuming because one
of
| cells is protected and it thinks I'm trying to change it.)
|
| What's the purpose of allowing adding and deleting rows to protected
sheets
| if it doesn't work when a row has a locked column.? bIs there any way
around
| this?
|
| Thanks