Locking text in cells but not the ability to change colour of cells with mouse click

[SStrat1]

[h=2]

Locking text in cells but not the ability to change colour of cells[/h]<ins style="text-decoration: none; display: inline-table; border: none; height: 60px; margin: 0px; padding: 0px; position: relative; visibility: visible; width: 234px;"><ins id="aswift_0_anchor" style="text-decoration: none; display: block; border: none; height: 60px; margin: 0px; padding: 0px; position: relative; visibility: visible; width: 234px;">******** width="234" height="60" frameborder="0" marginwidth="0" marginheight="0" vspace="0" hspace="0" allowtransparency="true" scrolling="no" id="aswift_0" name="aswift_0" style="left: 0px; position: absolute; top: 0px;">*********></ins></ins>

Hi
I have a spreadsheet where I can change the colour of a cell by clicking the mouse, I also have text in many of the cells.
What I need to do is protect (lock) the text so that no one can change the text in any of the cells, but I still want to be able to change the colour of the cells by clicking the mouse in that cell.

Any ideas would be greatly appreciated.

Thanks

Steve​

 

[Gerald Higgins]

Looks like a duplicate of this thread...
http://www.mrexcel.com/forum/excel-...ells-but-not-ability-change-colour-cells.html

 

[VoG]

Please do not post the same question multiple times. All clarifications, follow-ups, and bumps should be posted back to the original thread. Per forum rules, posts of a duplicate nature will be locked or deleted (rule #9 here: Forum Rules).