View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Mike H Mike H is offline
external usenet poster
 
Posts: 11,501
Default 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