Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How to update worksheet colours based on worksheet name | Excel Discussion (Misc queries) | |||
How to add comments/colours to cells in a protected sheet | Excel Discussion (Misc queries) | |||
Worksheet protection is gone and only wokbook protection can be se | Excel Discussion (Misc queries) | |||
Changing Colours With Protection | Excel Discussion (Misc queries) | |||
How can I link cell colours from worksheet to worksheet/workbook? | Excel Worksheet Functions |