R
Rafael Diaz
I have a protected sheet and just want to allow the user to paint on it (fill
color)
color)
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
S
SteveG
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
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
G
Gord Dibben
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
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
R
Rafael Diaz
Thanks.
Is this an option in Excell 2000 9 SR-1
Is this an option in Excell 2000 9 SR-1
R
Rafael Diaz
Thanks.
It is the 2000 version.
Can´t find that option in this version.
It is the 2000 version.
Can´t find that option in this version.