I have a program that generates a generic spreadsheet. When I copy the data from this sheet, and paste it in my "pretty" spreadsheet, it changes the formats in my sheet, and also locks the cells (Since the generic's cells are locked)... I protect all my sheets so other people at work can't modify any formulas or anything, so when it locks those cells, i have to unprotect the sheet to delete them.
What I need to know is how can I NOT allow copy and paste to change my cell formats? I already "Protect" my work sheets.
What I need to know is how can I NOT allow copy and paste to change my cell formats? I already "Protect" my work sheets.