I have a template sheet with both a LDdate and LDtime drop box on it. I use Code to create a copy of the sheet in a different file...is there a way to make the date and time static once it is selected so when the copied sheet is opened they remane as entered in the template sheet and don't update?