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. |
#2
|
|||
|
|||
locking some, but not all, properties of a cell
Hi
AFAIK not possible with the build-in protection functionality. This would require VBA (though checking for a color change is difficult and would require for example the OnTime method). So in total you may use something different: - indicate holidays also with an entry - use conditional formating for showing colors depending on your entry -- Regards Frank Kabel Frankfurt, Germany wrote: 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. |
#3
|
|||
|
|||
locking some, but not all, properties of a cell
-----Original Message----- Hi AFAIK not possible with the build-in protection functionality. This would require VBA (though checking for a color change is difficult and would require for example the OnTime method). So in total you may use something different: - indicate holidays also with an entry - use conditional formating for showing colors depending on your entry -- Regards Frank Kabel Frankfurt, Germany Thanks for the suggestion, Frank, but if it was all dependant on data entry into a cell, I couldn't stop users from entering vacation letters while still allowing them to enter shift letters. I can, of course, change the way the spreadsheet works, but what I need is to allow everybody to enter one set of criteria while preventing all but the administrator from entering a different set of criteria. I thought about using two sets of cells, a protected one for holiday planning and the other (unprotected) for shift planning, but there isn't enough space on the screen without scrolling. It wouldn't look as professional! Incidentally, I'm not frightened by Excel Basic, if you have some ideas to give me. 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 04:03 PM |
Link or paste cells based on Date in cell | Ayanna | Worksheet Functions | 0 | December 16th, 2003 07:10 PM |
Value in one cell changes the Text Properties in another...... | DoD_au | Worksheet Functions | 4 | December 16th, 2003 08:39 AM |
Question on LOGIC ?? - PLEASE HELP | PM | Worksheet Functions | 17 | November 28th, 2003 10:13 AM |