Assuming you allow any cell by any user to change the format?

--

Regards,
Nigel




"Ken Warthen" wrote in message
...
Nick,

That's the answer I was looking for. Thanks for the help.

Ken

"Nick H" wrote:

Hi Ken,

This is probably because the 'AllowFormattingCells' property is set to
false.

If you are manually protecting the sheet you can put a tick next to
'Format Cells' in the Protect Sheet dialog.

HTH, Nick H