Take the 2-minute tour ×
Super User is a question and answer site for computer enthusiasts and power users. It's 100% free, no registration required.

This is an old question - You can't really force validation rules in excel b/c even if you protect your sheet a simple copy/paste can bypass all validation (very strange implementation of protection from Microsoft and a poor one IMHO)

Now - There are many solution how to catch paste using VBA or even cancel it and force validation, but they worth nothing, as the user can disable vba code before opening the workbook and again we have no protection.

Is there a way to really protect the validation on cells (even by removing paste completely) WITHOUT USING VBA Code ?

share|improve this question
    
This isn't really an answer, but it may be interesting: social.technet.microsoft.com/Forums/office/en-US/… –  Dave Aug 15 '13 at 8:09

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Browse other questions tagged or ask your own question.