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
|
|||
|
|||
Formual Protection
Is there a way to lock a formula into a cell yet still allow the user to
alter its content without erasing the formula? ie I put an index function into a cell, but if the user wished they could change the cell, but if they mess up the formula is gone. --- Message posted from http://www.ExcelForum.com/ |
#2
|
|||
|
|||
Formual Protection
Either a cell contains a formula, which returns a value,
or a cell contains an entered value. You can't have both. -- Best Regards Leo Heuser Followup to newsgroup only please. "Aversin " skrev i en meddelelse ... Is there a way to lock a formula into a cell yet still allow the user to alter its content without erasing the formula? ie I put an index function into a cell, but if the user wished they could change the cell, but if they mess up the formula is gone. --- Message posted from http://www.ExcelForum.com/ |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
TWO THINGS! One Protection ... other Macros | Joe Cramblit | General Discussion | 9 | August 7th, 2004 04:32 PM |
Excel 2000 vs 2002 Sheet protection & Validation cells | Andre Croteau | General Discussion | 4 | July 17th, 2004 03:31 PM |
Excel 2000 - Worksheet Protection Problem | Norman Harker | Worksheet Functions | 1 | February 18th, 2004 08:58 AM |
Protection | Ralph | Worksheet Functions | 1 | October 28th, 2003 02:23 PM |