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
|
|||
|
|||
Q: locking some, but not all, properties of a cell
Folks,
Is there a way of locking the format of a cell, but not the contents? We have a shared yearly planner type spreadsheet in which cells are coloured to indicate vacation, on course, off sick, etc, and may also contain key letters to indicate Early or late shifts. I would like to allow anybody to input shift changes, but reserve changes in vacation (cell colour) for the administrator. Thanks - Mike. |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
**Trying to use answer from another formula cell in another formula | KIMBERLY | Worksheet Functions | 1 | April 27th, 2004 06:22 PM |
Lookup and highlight matching cell with colours | JE McGimpsey | Worksheet Functions | 0 | March 5th, 2004 03:03 PM |
Link or paste cells based on Date in cell | Ayanna | Worksheet Functions | 0 | December 16th, 2003 06:10 PM |
Value in one cell changes the Text Properties in another...... | DoD_au | Worksheet Functions | 4 | December 16th, 2003 07:39 AM |
Question on LOGIC ?? - PLEASE HELP | PM | Worksheet Functions | 17 | November 28th, 2003 09:13 AM |