Not able to Lock formula Cells

[Tejas.T]

Hi All,

Please see below attached file.
not able to lock formula cells.xlsx

The worksheet is locked without password.

Locking works on all cells except the formula range B9:G10

In fact, that is the main thing I need to keep protected. I tried a lot but even after I protect the sheet, I am able to change that range.

Can anybody please tell me what I am missing here?

Thanks,
Tejas

[AlKey]

When you go to Review, Protect Sheet uncheck everthing. and click OK

[TMS]

Doesn't seem to be a problem with the file. First, unprotect the sheet. Then set ALL cells to be LOCKED. Then set any cells where the user will input data to be UNLOCKED (remove the tick). Then Protect the worksheet (with or without a password. Deselect (untick) "Select locked cells"

See the updated example.


Regards, TMS

[Tejas.T]

Hi TMS, Alkey

I can see in your file I am not even able to select the locked Cells.
I want user to be able to select the locked cells. So if I keep the 1st two check boxes checked, the range B9:G10 becomes editable as well.

hope that makes sense.

Thanks.

[TMS]

With regard to being able to select locked cells, tick the box.

However, you have ...

Allow users to Edit Ranges:

Title: Range1_1.....Refers to: =$B$9:$O$10
Title: Range2........Refers to: =$B$7
Title: Range8........Refers to: =$C$6

All with no password. That over-rides the "standard" sheet protection. Not sure what you want to do about that.


Regards, TMS

[Tejas.T]

Hi TMS

Thanks a lot. That helped.
I didn't know about that option (Allow users to edit renges)

[TMS]

You're welcome. Thanks for the rep.



If you are satisfied with the solution(s) provided, please mark your thread as Solved.


New quick method:
Select Thread Tools-> Mark thread as Solved. To undo, select Thread Tools-> Mark thread as Unsolved.

Or you can use this way:

How to mark a thread Solved
Go to the first post
Click edit
Click Go Advanced
Just below the word Title you will see a dropdown with the word No prefix.
Change to Solved
Click Save


You may also want to consider thanking those people who helped you by clicking on the little star at the bottom left of their reply to your question.