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

M

Mike Mayer

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

Bill Manville

Mike said:
Is there any way to protect cells in Excel so that users
can only paste in text and not any formatting?
Click to expand...

Not directly
The best you can do is disable or remove the ability to paste other
than Paste / Values.

Bill Manville
MVP - Microsoft Excel, Oxford, England
No email replies please - reply in newsgroup
 
Top