How to stop info from being pasted into a cell that has a drop dow

L

lorettal

I need to prevent someone from overwiting information in a cell that has a
drop down box of items to choose from by not allowing them to paste
information they copied from other spreadsheets.
 
J

John C

You can still paste over DV, no matter the DV (at least in xl2003). There
really isn't a practical way to prevent it.
 

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

Paragraph numbering in Word 1
How to paste this down? 3
Paste to excel from word - auto format problem 1
Pasting a range to a single cell 0
Drop down box w/contents of different worksheet? is this possible 1
Copy corresponding cell in Column B if cell in A contains certain text? 1
Having difficulty with Microsoft date & time picker in excel 2010 0
Prevent Cut and Paste 3

Top