Rules of operation

If you lock a cell with a formula, all the component cells of the formula will also be locked.

Locking cells affects only the current worksheet for the current data slice.