Worksheet Protection & Comments/Colours
 

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

Worksheet Protection & Comments/Colours
 

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

Worksheet Protection & Comments/Colours
 

Hi

When using ToolsprotectionProtect Sheet scroll down the list a tick
Format cells and tick Edit Objects

--
Regards
Roger Govier

"Primary School" wrote in message
...
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