NewBie questions
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
|