Locking cells or hiding formulas has no effect until you protect the worksheet (Review tab, Changes group, Protect Sheet ...