Delete Rows in a protected worksheet
Hi,
The ability to delete rows on a protected sheet relies upon those rows being
unlocked.
Select the row(s) you want to be able to delete then
Format)Cells|Protection
remove the locked checkmark
Protect your sheet and you can still delete these rows.
Mike
"Kathy Connelly" wrote:
I need to be able to delete rows in a protected worksheet.
When I protect the worksheet it gives me the option to be able to allow a
user to delete rows - I check that box. However, it will not allow me to
delete the rows after I protect it.
Can you tell me what I need to do?
--
Kathy Connelly
|