Formatting in a Protected Spreadsheet

[Ang]

I have a password protected spreadsheet that only allows end users to enter
data into specific cells. Is it possible to allow the end user to format
(bold, italics, color) those specific cells, also? Currently, no formatting
is allowed because the spreadsheet's protected and locked.

Thx much!

 

[Harlan Grove]

I have a password protected spreadsheet that only allows end users
to enter data into specific cells. Is it possible to allow the end
user to format (bold, italics, color) those specific cells, also?
Currently, no formatting is allowed because the spreadsheet's
protected and locked.

There's no way to allow users to format only unlocked cells. Either
they can't format any cells, or they can format all cells.

 

[Barb Reinhardt]

When you protect the worksheet, you can allow formatting.

 

[Ang]

How?

When you protect the worksheet, you can allow formatting.

 

[JMB]

I don't think that feature is available in all XL versions. I'm not sure
when it was added.

 

[Gord Dibben]

If using Excel 2002 or newer you can designate "allow formatting" on those
specific cells when you are protecting the sheet under Tools>Protection>Protect
Sheet


Gord Dibben MS Excel MVP

 

[Harlan Grove]

If using Excel 2002 or newer you can designate "allow formatting"
on those specific cells when you are protecting the sheet under
Tools>Protection>Protect Sheet

....

In Excel 2003 in the Protect Sheet dialog under the 'Allow all users
of this worksheet to:' section there's a checkbox labeled 'Format
cells'. If I check it and click the OK button, I can format BOTH
locked and unlocked cells. If when protecting the worksheet I UNcheck
the 'Select locked cells' checkbox, then I can only select unlocked
cells in that worksheet. However, I could select both the protected
worksheet and another worksheet in which there were either no or
different selection restrictions, then I could format the cells in the
grouped worksheets, thereby formatting locked cells in the protected
sheet.

Or did you mean something else?