View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.misc
Roger Govier[_3_] Roger Govier[_3_] is offline
external usenet poster
 
Posts: 2,480
Default 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