"Locking" cells
"Locking" cells
(OP)
Using Excel, is there any method of "locking" individual cells, but not the entire workbook?
I want our guys to be able to change data in some cells, but not allow them to "accidentally" erase the formulas in others.
Thanks for any help.
I want our guys to be able to change data in some cells, but not allow them to "accidentally" erase the formulas in others.
Thanks for any help.





RE: "Locking" cells
Hope that helps...
DimensionalSolutions@Core.com
While I welcome e-mail messages, please post all thread activity in these forums for the benefit of all members.
RE: "Locking" cells
You can use styles and specify locked/unlocked cells for each style.
Remember, the cells won't actually be locked until you protect the sheet/workbook with Tools, Protection, Protect Sheet/Protect Workbook.
RE: "Locking" cells