View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.misc
Gord Dibben Gord Dibben is offline
external usenet poster
 
Posts: 22,906
Default allow fill color to protected cell

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)