Allowing editing locked cells in a protected sheet in excel

P

phoenix

Hi,

1. I have an protected excel sheet in which Columns A,B,C are locked and
cannot be editted by everyone however columns D and E are open to be edited
by everyone.
2. However my problem is when I click on protect worksheet and add myself in
the permissions tab to edit without password, I cannot edit and the whole
sheet gets locked. This is not expected.

Please help
 
L

Luke M

If columns D & E are formatted to not be locked, you should always be able to
edit them. Are you making sure to enter the same password for both the ranges
you can edit, as well as the password to protect workbook?

When you add yourself, make sure your checking the name, so computer
verifies it recognizes what you inputted.

Other than that, I'm not sure, as I am unable to duplicate your problem.
 

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

Change cell color in protected sheet 1
I can still select & manipulate locked & protected cells in '07 1
allow a user to edit ranges in a protected worksheet 3
Sorting a protected set of cells 3
Sorting a protected sheet 1
Deleting Rows Containing Protected Cells 2
How do you insert & delete rows in a protected worksheet? 1
Modifying a locked/protected sheet 3

Top