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

  • Thread starter Thread starter Mike Mayer
  • Start date Start date
M

Mike Mayer

Is there any way to protect cells in Excel so that users
can only paste in text and not any formatting?
 
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
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

select all cell containing any formula and not text or number 2
Protecting cells in Excel so that users can only paste in text 1
Excel Protection 2
Macro that will insert a simple text string in top cell of text file 1
Protect Number Format Only 7
Excel Data pastes into 2 cells not 1 1
Replace normal paste with Paste As Text 3
Controlling worksheet protection via VBA 0

Back
Top