If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Partial cell protection?
I'm using Excel 2003 anbd have set up a pretty basic worksheet for colleagues
to complete as far as an call centre rota is concerned. Different cells are coloured differently and cell borders vary - is it possible to partially protect the worksheet, so that colours and borders CAN'T be changed, but cells can still be written into, and information from one cell (eg a name) can be copied into other cells without changing the colour / border format of the destination cells?? As always, thank you in anticipation. |
#2
|
|||
|
|||
Partial cell protection?
Unlock the cell
Format|Cells|Protection tab But prtect the worksheet. The value should be able to be changed. The formatting should not be able to be changed manually. The bad news is that the format can be changed by a simple copy|paste. You may have to train your users to use edit|Paste special|Values Anglepoise wrote: I'm using Excel 2003 anbd have set up a pretty basic worksheet for colleagues to complete as far as an call centre rota is concerned. Different cells are coloured differently and cell borders vary - is it possible to partially protect the worksheet, so that colours and borders CAN'T be changed, but cells can still be written into, and information from one cell (eg a name) can be copied into other cells without changing the colour / border format of the destination cells?? As always, thank you in anticipation. -- Dave Peterson |
Thread Tools | |
Display Modes | |
|
|