Protecting cells in Excel so that users can only paste in text

M

michael.mayer

Is there any way to protect cells in Excel so that users
can only paste in text and not any formatting?
 
P

Patrick Molloy

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.
 
Top