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

ExcelBanter (https://www.excelbanter.com/)

- Excel Programming (https://www.excelbanter.com/excel-programming/)

- - Protect cells in Excel so that users can only paste in text (https://www.excelbanter.com/excel-programming/284307-protect-cells-excel-so-users-can-only-paste-text.html)

Mike Mayer

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

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

Bill Manville

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

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

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

All times are GMT +1. The time now is 05:01 PM.