Felix Felix Asadu
New Member
- Joined
- May 1, 2022
- Messages
- 11
- Office Version
- 365
- Platform
- Windows
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.
worksheet formula to calculate and display results, not to protect cell.
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.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.
Yes, I want to lock cells with Formula. I just want to know the different ways of doing this aside protecting the worksheetIs this what you want: "lock cells those have formula"
NOT
"using formula to lock specific cells"
???
I just want to protect cells with formulas. But I want to learn different ways of doing it, if not only protecting the sheetYou have not explained why you don't want to lock the cell & protect the sheet. That would be an easy way.