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<dot>moore@pandora<dot>be
Adjust "dots" for real address
"Dave Peterson" <[email protected]> wrote in message
news:[email protected]...
> 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<dot>moore@pandora<dot>be
>> Adjust "dots" for real address
>
> --
>
> Dave Peterson