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

  • Thread starter Thread starter michael.mayer
  • Start date Start date
M

michael.mayer

Is there any way to protect cells in Excel so that users
can only paste in text and not any formatting?
 
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.
 
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
Protect 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