Formatting in a Protected Spreadsheet

G

Guest

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!
 
H

Harlan Grove

Ang said:
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.
Click to expand...

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.
 
G

Guest

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

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
 
H

Harlan Grove

Gord Dibben said:
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
Click to expand...
....

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?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

use source formatting with protected worksheet 2
Protect conditional formatting in destination cell 2
Is autofilter & sort disabled in protected cells? 1
Change cell color in protected sheet 1
Sorting a protected sheet 1
allow a user to edit ranges in a protected worksheet 3
macro to disallow shading in certain columns 2
Merging cells in a Protected Sheet 2

Top