Which version of Excel?
2002 and newer allow cell formatting when protected.
ToolsOptionsProtect 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
wrote:
I have a protected sheet and just want to allow the user to paint on it (fill
color)