Hi

When I protect a worksheet, even when a particular cell is unlocked,
users are unable to change the font size, number of decimals in a
calculation, colour of text, bold it, change the width of the colums
etc.

Is there anyway to allow users to make these alterations, while still
protecting other (locked) cells on the same worksheet?

Thanks for your thoughts / advice

andrew.

If you are using xl2002/2003 then you can protect the sheet and allow users
to format cells, unfortunately this means all cells not just those unlocked.
Earlier versions do not have this feature.

I believe that you would need to dynamically unprotect the sheet, test the
cells for those you allow users to change (named ranges for example) then
protect the sheet again, all under the control of a VBA program triggered
by the change events.

Cheers
Nigel

"Andrew" wrote in message
om...
Hi

When I protect a worksheet, even when a particular cell is unlocked,
users are unable to change the font size, number of decimals in a
calculation, colour of text, bold it, change the width of the colums
etc.

Is there anyway to allow users to make these alterations, while still
protecting other (locked) cells on the same worksheet?

Thanks for your thoughts / advice

andrew.