Good day
I manage a Work Order tracker that is used by many people in my organization. I have added some conditional formatting and formula's to make my life easier, but need to protect my document from unwanted changes. When a new entry is added, we "Copy" and "Insert Copied Cells" the last row to keep all the formatting. I can get my cells to paste over but what happens is the "Locked" cells are now no longer locked. With the people using the sheet, I need the properties to be copied over every time. Not sure if this is possible but I need this to work this way cause I can’t change people’s habits.
Any help would be great,
Bookmarks