speytone
Jun 27 2008, 11:20 AM
I just made a spreadsheet and i have formuals in certain rows i do not want to have changed. I understand to protect things i have to protect the sheet. But becasue some people will be needed to make changes to different variables i need to have certain cells "unlocked" so that they can go in and freely input there info on a weekly basis but not have the ability to delete the forumlas i wish to have locked in.
Can anyone help me please.
Time is of the essence.
Im handing the reigns over on monday.....
Thanks for any and all help.
tos226
Jun 27 2008, 01:45 PM
Protect the entire sheet. Then unprotect cells you allow to change.
speytone
Jun 27 2008, 04:39 PM
Yea ifigured thats what i have to do. but when i go to format those cells to unprotect it its not letting me choose the format feature?
Am i missing something. I password protected it when i protected it. Does that have something ot do with it.
I think im missing something
tos226
Jul 1 2008, 06:21 PM
I'm not sure I understand what you wrote.
Once a cell is protected, none of the editing functions work, be it editing values, formats, column widths etc, most menu items are disabled.
If you're trying to unprotect a protected cell, I'd think reversing the process would work - unprotect the sheet, edit, reprotect again for the cells you need.