I have a sheet where I want to lock columns that auto calculate with a formula, but have the person entering the data being able to insert a row and have the formulas copy from the locked cells in the column so she never has to be given the password. Can this be done? And how?