Edit text format in non-protected cells in protected worksheet
Is there a way to allow users to edit their text input within a cell that is
NOT locked (accessible to the user) within a password-protected Excel
worksheet?
Please be specific in answering, I found the "Allow Users to Edit Ranges"
(under the Tools Protection menu) but can't understand how to set it up.
The Excel worksheet has to be protected against modification of formulas,
etc. but has just as many cells that a user must enter data, including a
"Remarks" field. It is within this field I want to allow users to format
their own text as they wish (i.e., highlight, or change font color). All
users (in a very large group) should be able to do this.
--
Thank you for your time and effort in replying to my question.
Bonnie
|