If you are using xl2002 or later, when you protect the sheet, click the box
to allow format cells I would think (worked for me). In earlier versions,
there is no such setting.

--
Regards,
Tom Ogilvy


"Gizmo63" wrote:

Hi all,

Is there a cunning line of VBA code that will modify protection settings so
users can change the font colour in unlocked cells within a protected
spreadsheet?


Cheers
Giz