Formula to protect cells

[Felix Felix Asadu]

I don't want to lock or protect cells. So is there any formula that I can use to protect my cells with formula? I don't want a VBA code please.

 

[bebo021999]

worksheet formula to calculate and display results, not to protect cell.

 

[Felix Felix Asadu]

The results will be displayed, but the cell should be protected. You know you can use Ctrl+1 to lock cells..I don't want that, I want a formula to do that .

worksheet formula to calculate and display results, not to protect cell.

 

[Peter_SSs]

Seems like you are saying that you do not want to protect cells but you want to protect cells.

Looks to me that the answer is "No" but perhaps you could tell us more about what you are trying to achieve and why.

 

[bebo021999]

Seems like you want to type in cell A1:
="I want to protect this cell, without lock it, and without using format cell"

It's impossible.

 

[Felix Felix Asadu]

Seems like you want to type in cell A1:
="I want to protect this cell, without lock it, and without using format cell"

It's impossible.

Thank you all for your responses,you are right. All I want to do is to lock a cell with a FORMULA so nobody can edit or delete.

If there's no formula, then VBA please. Thank you.

 

[Peter_SSs]

You have not explained why you don't want to lock the cell & protect the sheet. That would be an easy way.

 

[bebo021999]

Is this what you want: "lock cells those have formula"
NOT
"using formula to lock specific cells"
???

 

[Felix Felix Asadu]

Is this what you want: "lock cells those have formula"
NOT
"using formula to lock specific cells"
???

Yes, I want to lock cells with Formula. I just want to know the different ways of doing this aside protecting the worksheet

 

[Felix Felix Asadu]

You have not explained why you don't want to lock the cell & protect the sheet. That would be an easy way.

I just want to protect cells with formulas. But I want to learn different ways of doing it, if not only protecting the sheet