Sheet protection

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I'm using Excel 2002. My problem is when I protect my sheet, I checked off
the box where I can allow all users to delete rows. But when I tested it, it
won't let me delete rows. It says, "You are trying to delete a row that
contains a locked cell. Locked cells cannot be deleted while the worksheet
is protected." I have selected ranges where I'm allowing users to edit cells
within the range and these rows that can be added or deleted are within those
ranges. I have no problem inserting rows, just deleting them. Can anyone
help me?

Thanks!
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Can't use protection options 1
Allowing row deletion in worksheet with locked cells 2
ProtectSheet Options are un-checking after macro 9
Deleting Rows form Protected Sheet 1
Protected sheet - attempt to delete row = unmerged cells 5
Delete rows while sheet protected 3
backing up formulas in sheet coding? 2
Protect 2

Back
Top