Hiding formula without protecting sheet

[Hobie626]

Is there a way to hide formulas other than format cell/hide then protecting sheet? I see several threads on the subject but it seems that is the only solution people recommend. That solution does not fit my needs. Can anyone help with an alternative? Thanks in advance.

 

[Peter_SSs]

Is there a way to hide formulas other than format cell/hide then protecting sheet? I see several threads on the subject but it seems that is the only solution people recommend. That solution does not fit my needs. Can anyone help with an alternative? Thanks in advance.

That's the only way I know. Can you explain how it doesn't fit your needs?

 

[Hobie626]

Here's why I say that protecting the sheet/cells will not work for me... The spreadsheet that I have designed includes a list box. When the user selects from the list it changes the cell formulas. When the cells are protected, the user is then not able to change the selection in the list box. Hope I'm explaining it clearly.

 

[Peter_SSs]

Here's why I say that protecting the sheet/cells will not work for me... The spreadsheet that I have designed includes a list box. When the user selects from the list it changes the cell formulas. When the cells are protected, the user is then not able to change the selection in the list box. Hope I'm explaining it clearly.

Can you tell us a bit more about the list box? What is in it? How does it interact with the worksheet? That is, how does it change the formulas when the user selects something from the list? Just trying to get a better understanding of what you have and what you are trying to achieve to see if I can suggest something useful.

Edit: Also, the formula cell location might be useful.

 

[Hobie626]

The list box controls an 'If' statement. There is also an 'Index' command in the same formula. For example, 'If cell K1="1" Index this otherwise Index that. Cell K1 is driven by the list box. It's a pretty complicated sheet but that's the general issue.

 

[Peter_SSs]

So it seems to me that the ListBox just feeds number into cell K1. A formula in another cell refers to K1 to do its calculation. If that is the case, with the sheet unprotected, can you do this?

1. Select cell K1

2. Format|Cells...|Protection tab|removed tick from 'Locked'|OK

3. Protect the sheet.

Now the formula cells will be protected/hidden but the ListBox should still be able to feed its value into K1, which doesn't need protection because it dosn't conatain a formula.

 

[Hobie626]

Yes that worked. I thought locking the formula cells were causing the problem. Thank you very much.