Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Protection for formulas
--------------------------------------------------------------------------------
I am creating a user template for a rankings program. I was wondering if there was a way to lock a sheet (or even the whole file) so that nothing can be modified. However, I do want the user to be able to change data, input their own numbers and names, etc. I just do not want them to change the formulas. Is this possible? Basically, here is what I want to do: I have columns set up like this A1 B1 C1 enter name in any order here automatically sorts into order puts on sheet I want users to change the names on C1, but if a name is entered into A1 again then it will be appropriatly placed (even if it overwrites a name in the C column) Does this make sense? TIA |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
cell protection | Excel Discussion (Misc queries) | |||
Cell protection in Excel is lost when file is uploaded to website. | Excel Discussion (Misc queries) | |||
workbook protection | New Users to Excel | |||
protection on excel forms | Excel Worksheet Functions | |||
How may I remove Office 2003 DRM protection from DOC & XLS files? | Excel Discussion (Misc queries) |