+ 0 Votes I don't understand LocoLobo 7 years ago Do you want to move the protected cells to another location? Would Copy -> Paste work? Copy will work and in Excel 2003 you can allow inserting rows and columns. Nothing I tried worked either. Which is good for me. We don't want our users moving protected cells around. Maybe someone else here can help + 0 Votes Can you clarify? liz 7 years ago The formulas are already all there. Are you suggesting that I can add into the macro to first unprotect the sheet, do the add rows sequence, then protect the sheet? If I can do that, I think that will solve the problem. Thanks! + 0 Votes Named range may work toms45 Updated - 7 years ago Try putting your formulas way down in row 3000 column az in a named range, then reference the named range in the calculated cells. Seems like I remember something like this from about 10 years ago. + 0 Votes There are two ways to do this fwang 7 years ago 1) Give user password (or protect sheet without password), unprotect sheet, then do cut/paste, after that, protect sheet again. 2) Do not put any formula, after user finishes all the cut/paste job. Run a macro to generate all the formula. You can also use macro to protect the final sheet and lock it.