I dug down into some of the questions below, and managed to find the solution
which was to tick the Edit Object and Format Cells checkboxes when protecting
your worksheets.

Thanks to the discussion group comments for this worthwhile way of finding
out new things in Excel easily. Much appreciated.
--
ICT Info - Primary School


"Primary School" wrote:

I've designed a shared file where the teachers need to colour code cells/rows
and insert comments. However, when I protect the worksheet it prevents these
commands from being used. Any advice please. Thanks
--
ICT Info - Primary School