Excel Data Validation
Hi there
I wish to prevent certain values (eg: the words "Expenses", or "Exps")
from being entered into a cell...they can enter any other
description/words they like (up to say, 40 characters), I just don't
want them to be able to enter either of those mentioned above....how
do I do it? VBA?
The data validation function is just not cutting the mustard, but it
may be I'm overlooking something simple...?
thanks in advance - really appreciate any help
Sue
|