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
|
|||
|
|||
Can I conditionally UNLOCK a cell?
I have protected my workbook, leaving certain cells
unlocked so users can value them. Based on the values that my user choose, I will auto-populate a tangent cell with either YES or NO (this cell will be locked). Question: If the auto-populated cell value is YES, I want to (a) auto-populate an subsequent tangent cell with a value (defined from a validation list) and (b) unlock the cell to allow my users the ability to change the auto- populated value I defaulted. However, if the auto- populated cell value is NO, I will (a) default the value of the subsequent tangent cell but (b) keep the cell locked. Any ideas of how to do this? Note: if need be, I have provided some examples to better explain my "hopeful" worksheet processing. Ex. 1 A1 = 200 (unlocked so user can select from list) B1 = Car (unlocked so user can select from list) C1 = YES (locked cell; auto-populated with YES based on A1,B1 condition) D1 = defaulted value - but change-able. Since C1 = YES, D1 is value to something I default from a validation list and (b) is now "unlocked" so my users can change the default value if it is inappropriate. Ex. 2 A1 = 200 (unlocked so user can select from list) B1 = Bike (unlocked so user can select from list) C1 = No (locked cell; auto-populated with NO based on A1,B1 condition) D1 = defaulted value - and unchange-able. Since C1 = NO, D1 is value to something I default from a validation list and (b) remains "locked" so my users cannot change the default value. |
#2
|
|||
|
|||
Hi
if I understood your requirements correctly this is not possible without VBA (using an event procedure). As a starting point see: http://www.cpearson.com/excel/events.htm -- Regards Frank Kabel Frankfurt, Germany "Chris" schrieb im Newsbeitrag ... I have protected my workbook, leaving certain cells unlocked so users can value them. Based on the values that my user choose, I will auto-populate a tangent cell with either YES or NO (this cell will be locked). Question: If the auto-populated cell value is YES, I want to (a) auto-populate an subsequent tangent cell with a value (defined from a validation list) and (b) unlock the cell to allow my users the ability to change the auto- populated value I defaulted. However, if the auto- populated cell value is NO, I will (a) default the value of the subsequent tangent cell but (b) keep the cell locked. Any ideas of how to do this? Note: if need be, I have provided some examples to better explain my "hopeful" worksheet processing. Ex. 1 A1 = 200 (unlocked so user can select from list) B1 = Car (unlocked so user can select from list) C1 = YES (locked cell; auto-populated with YES based on A1,B1 condition) D1 = defaulted value - but change-able. Since C1 = YES, D1 is value to something I default from a validation list and (b) is now "unlocked" so my users can change the default value if it is inappropriate. Ex. 2 A1 = 200 (unlocked so user can select from list) B1 = Bike (unlocked so user can select from list) C1 = No (locked cell; auto-populated with NO based on A1,B1 condition) D1 = defaulted value - and unchange-able. Since C1 = NO, D1 is value to something I default from a validation list and (b) remains "locked" so my users cannot change the default value. |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
IF E3 & E10 = TRUE set this cell to "Yes", else set to "No" | Timothy L | Worksheet Functions | 5 | August 27th, 2004 02:28 AM |
Conditionally formating an Excel cell based on insertion point | gmrath | General Discussion | 1 | August 24th, 2004 02:41 PM |
conditionally taking information from a cell | jcm2313 | Worksheet Functions | 2 | August 21st, 2004 04:15 AM |
Link or paste cells based on Date in cell | Ayanna | Worksheet Functions | 0 | December 16th, 2003 06:10 PM |
Question on LOGIC ?? - PLEASE HELP | PM | Worksheet Functions | 17 | November 28th, 2003 09:13 AM |