• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 397
  • Last Modified:

Lock Cells/Protect Sheet

Hi,

I have a sheet with cells I need to Lock. Once I do that and then protect the sheet, users can input data into unlocked cells but they can't change formatting (colors) on any cell in the sheet. I only wanted to lock certain cells, not disallow formatting in every cell.

Any input would be appreciated.

Thanks in advance,

swjtx99
0
swjtx99
Asked:
swjtx99
1 Solution
 
chaauCommented:
You need to check the "Format cells" checkbox in the "allowed actions" when locking the sheet. See the screenshot belowSheet Protection Options
0
 
bbaoIT ConsultantCommented:
0
 
Martin LissRetired ProgrammerCommented:
And you may know this, but to follow up on what chaau posted, you then select the cells you want to lock, right click on them and choose 'Format Cells', select the 'Protection' tab and check 'Locked'.
0
 
swjtx99Author Commented:
Thanks,

It was staring me in the face the whole time :-)

Regards,

swjtx99
0

Featured Post

How to Use the Help Bell

Need to boost the visibility of your question for solutions? Use the Experts Exchange Help Bell to confirm priority levels and contact subject-matter experts for question attention.  Check out this how-to article for more information.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now