Excel offers no such constraint. If someone is determined to enter bad data, they can simply paste values over a validated range or open the file in another program to completely bypass the rules I ...

The last piece of this three-part article is about merging your custom Word documents with your client list (exported from Outlook to Excel) for distribution. Part One explains how to selectively ...