M michael.mayer Dec 3, 2003 #1 Is there any way to protect cells in Excel so that users can only paste in text and not any formatting?
Is there any way to protect cells in Excel so that users can only paste in text and not any formatting?
P Patrick Molloy Dec 3, 2003 #2 don't think so.you could have them paste to a blank sheet then copy it in, or use code to get th edata from the file or finally, use code to re-format the data after the import.
don't think so.you could have them paste to a blank sheet then copy it in, or use code to get th edata from the file or finally, use code to re-format the data after the import.
