I was wondering if there is a way to lock rows so that no one can change them by inserting another row? I have formulas set up in another sheet which reference certain rows in another sheet. I also need to be able to copy and paste info so I can't lock the sheet for editing. Any help would be helpful.