OpenOffice.org Forum at OOoForum.orgThe OpenOffice.org Forum
 
 [Home]   [FAQ]   [Search]   [Memberlist]   [Usergroups]   [Register
 [Profile]   [Log in to check your private messages]   [Log in

How do you lock the formulas but leave the cells workable?

 
Post new topic   Reply to topic    OOoForum.org Forum Index -> OpenOffice.org Calc
View previous topic :: View next topic  
Author Message
JackieBaby
General User
General User


Joined: 02 Sep 2007
Posts: 11

PostPosted: Thu Sep 13, 2007 5:50 pm    Post subject: How do you lock the formulas but leave the cells workable? Reply with quote

In my workbook I have lots of cells with formulas, one result leads to the next..., I would like to 'lock' the formulas, yet leave the contents, (numbers, names, what have you), available to be altered. Right now when I try to lock the formulas I end up locking the whole sheet and I cant add or alter any data. If I leave them unlocked, and change a value in a formulated cell with out changing the input values, I alter or erase the formula.

Thanks
Jack
Back to top
View user's profile Send private message
davidh182
OOo Advocate
OOo Advocate


Joined: 01 Apr 2004
Posts: 413

PostPosted: Thu Sep 13, 2007 10:30 pm    Post subject: Reply with quote

Before protecting the sheet you can select certain cells to be unprotected. [ie the cells without formulas in]

Do this by format cells... Cell protection tab
Back to top
View user's profile Send private message Send e-mail
JackieBaby
General User
General User


Joined: 02 Sep 2007
Posts: 11

PostPosted: Fri Sep 14, 2007 4:14 pm    Post subject: Doesn't seem to work Reply with quote

I have already tried this, but I tried it again. The way the cell protection dialog reads implies that I must protect the sheet, but when I do that then I can't add any data. I want to protect the formulas, but not the sheet. If that makes any sense.

Jack
Back to top
View user's profile Send private message
David
Super User
Super User


Joined: 24 Oct 2003
Posts: 5668
Location: Canada

PostPosted: Fri Sep 14, 2007 6:48 pm    Post subject: Re: Doesn't seem to work Reply with quote

You can select the whole sheet by clicking the small rectangle upper left. Choose to unprotect. Select the formulated cells [you'll have to now pick and choose] and format them as protected, then protect the sheet.

HOWEVER ...It is far more normal procedure to select only those active [date or formula] cells you want to unprotect [such as those requiring data entry] and do them separately, rather than this way around. Then protect the sheet, and those cells you chose will still allow data entry.

David.
Back to top
View user's profile Send private message
JackieBaby
General User
General User


Joined: 02 Sep 2007
Posts: 11

PostPosted: Sat Sep 15, 2007 8:39 am    Post subject: OK I get it now Reply with quote

Thanks to both Davids here. They both make sense once I did it properly. I was going about it wrong before, convinced I was right. People do that all the time!

Thanks again
Jack
Back to top
View user's profile Send private message
David
Super User
Super User


Joined: 24 Oct 2003
Posts: 5668
Location: Canada

PostPosted: Sat Sep 15, 2007 9:38 am    Post subject: Re: OK I get it now Reply with quote

JackieBaby wrote:
I was going about it wrong before, convinced I was right.


So my wife tells me. ...Married 40 years tomorrow. Wink

David.
Back to top
View user's profile Send private message
JackieBaby
General User
General User


Joined: 02 Sep 2007
Posts: 11

PostPosted: Sat Sep 15, 2007 10:09 am    Post subject: Married 1/2 that long Reply with quote

Very Happy Yeah, we're working on 40 as well but we have aways to go yet. My wife lets me know the same thing!
Back to top
View user's profile Send private message
Display posts from previous:   
Post new topic   Reply to topic    OOoForum.org Forum Index -> OpenOffice.org Calc All times are GMT - 8 Hours
Page 1 of 1

 
Jump to:  
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum


Powered by phpBB © 2001, 2005 phpBB Group