allow fill color to protected cell

I have a protected sheet and just want to allow the user to paint on it (fill
color)

Rafael,

When you protect the sheet, make sure you select the Format Cells option in the list of edit permissions. Unfortunately, this also allows the user to change other things about the format like border, font, etc...

HTH

Steve

Thanks.

Is this an option in Excell 2000 9 SR-1

"SteveG" wrote:

>
> Rafael,
>
> When you protect the sheet, make sure you select the Format Cells
> option in the list of edit permissions. Unfortunately, this also
> allows the user to change other things about the format like border,
> font, etc...
>
> HTH
>
> Steve
>
>
> --
> SteveG
> ------------------------------------------------------------------------
> SteveG's Profile: http://www.excelforum.com/member.php...fo&userid=7571
> View this thread: http://www.excelforum.com/showthread...hreadid=563422
>
>

Which version of Excel?

2002 and newer allow cell formatting when protected.

Tools>Options>Protect Sheet.

Choose from the options in the dialog box.


Gord Dibben MS Excel MVP

On Thu, 20 Jul 2006 11:02:01 -0700, Rafael Diaz <Rafael
Diaz@discussions.microsoft.com> wrote:

>I have a protected sheet and just want to allow the user to paint on it (fill
>color)

Thanks.

It is the 2000 version.

Can´t find that option in this version.

"Gord Dibben" wrote:

> Which version of Excel?
>
> 2002 and newer allow cell formatting when protected.
>
> Tools>Options>Protect Sheet.
>
> Choose from the options in the dialog box.
>
>
> Gord Dibben MS Excel MVP
>
> On Thu, 20 Jul 2006 11:02:01 -0700, Rafael Diaz <Rafael
> Diaz@discussions.microsoft.com> wrote:
>
> >I have a protected sheet and just want to allow the user to paint on it (fill
> >color)
>
>