Help - Search - Members - Calendar
Full Version: Excel Cell Protection.
BleepingComputer.com > Software > Business Applications
   
speytone
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
Protect the entire sheet. Then unprotect cells you allow to change.
speytone
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
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.
This is a "lo-fi" version of our main content. To view the full version with more information, formatting and images, please click here.
Invision Power Board © 2001-2008 Invision Power Services, Inc.