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