1

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 ?

1

0

You must log in to answer this question.

Browse other questions tagged .