Dave, I don't want to unlock those cells, they contain formulas that I'm
afraid I might accidentally delete. It would be nice if I (or my users)
didn't have to unprotect the sheet each time.

Is there any other solution?

Regards,
Paul

--
paul<dotmoore@pandora<dotbe
Adjust "dots" for real address
"Dave Peterson" wrote in message
...
Unlock those cells to start
or
unprotect the worksheet, do the deletion and then reprotect the worksheet?

Paul Moore wrote:

Hello,

I'm trying to find a way to overcome a "feature" I've dicovered with
Excel
protection. If protection is enabled, with the "delete row" checkbox
active,
the row cannot be deleted if there are locked cells in the row.

Is there a way to defeat this "feature"?

Cheers,
Paul excel beginner

--
paul<dotmoore@pandora<dotbe
Adjust "dots" for real address

--

Dave Peterson