Worksheet Protection & Comments/Colours

[Primary School]

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

 

[Primary School]

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.

 

[Roger Govier]

Hi

When using Tools>protection>Protect Sheet> scroll down the list a tick
Format cells and tick Edit Objects