Hi

issue 1: maybe have your validation be a custom validation with formula

=Or(A2 = "SPEAKING","")
The problem is that an empty string is not a blank.

issue 2: in the VBA IDE go toTools - VBA Project Properties -
Protection and password-protect your project. Evidently, it is not the
strongest encryption in the world, but is adequate for most purposes.

Hope that helps

-John Coleman

x-rays wrote:
Hello all,

here is my 1st issue:

I've created a Name Range and use it in a validation data List of a
cell (consider it as A2). In A2 cell I've also placed an IF statement
like this one IF(A1="BLABLA";"SPEAKING";""), now my problem is that
when A1 < BLABLA then a message appears "The value you entered is not
valid. A user has restricted values that can be entered into this
cell." for A2 cell. The validation I created for this cell has been
marked to ignore blanks but as it seems it doesn't work right.

What I have to do for this?

2nd one:

How to encrypt or restrict by viewing my vba code I wrote when I want
to distribute my file?

Thanks in advance