Preventing pasting into cells but allow typing

[marnee]

I have a spreadsheet with lots of validation, and want users to type the entries or select from a drop-down. How, despite having explained it carefully to them all, do I prevent them pasting information into the spreadsheet from another one that they have created as this destroys al the validation etc?

[Portuga]

One way to do it is to protect the sheet and allow only for those cells to have values coming only from the drop down (no typing)...

Cant think of any other way. If you allow for inputing cell manually, it will allow for pasting also.

[marnee]

Only problem is that I have to allow typing in some cells as it is being used as a sort of database with text input because the employer does not have a database and existing data has to be updated on a regular basis in a text format. Also for example I need to produce stats using the name of an individual as the basis but even if I use a drop-down the information gets overtyped when the silly Bs paste in all their data!

[Leith Ross]

Hello marnee,

Here is macro you can run to disable the Paste command in the workbook. If you want to enable the Paste function, change Status to True.

Please Login or Register  to view this content.

Adding the Macro
1. Copy the macro above pressing the keys CTRL+C
2. Open your workbook
3. Press the keys ALT+F11 to open the Visual Basic Editor
4. Press the keys ALT+I to activate the Insert menu
5. Press M to insert a Standard Module
6. Paste the code by pressing the keys CTRL+V
7. Make any custom changes to the macro if needed at this time
8. Save the Macro by pressing the keys CTRL+S
9. Press the keys ALT+Q to exit the Editor, and return to Excel.

To Run the Macro...
To run the macro from Excel, open the workbook, and press ALT+F8 to display the Run Macro Dialog. Double Click the macro's name to Run it.

Sincerely,
Leith Ross