![]() |
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 |
All times are GMT +1. The time now is 07:53 AM. |
Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com