Yes. The spreadsheet has a couple of forms and a macro module with about 30
custom subroutines and functions. There are on sheet validations set. I
don't do any validation from within VBA. I prefer the use of listboxes
instead. However, both on sheet validations and VBA based macros use the
same "named" cell ranges which contain the content of the picklists used.

"Ronald Dodge" wrote:

Are there macros in this workbook including under that particular worksheet
or workbook on the VBA side of Excel or a macro sheet?

--
Ronald R. Dodge, Jr.
Production Statistician/Programmer
Master MOUS 2000

"TimK" wrote in message
...
I have a spreadsheet where certain cells will not accept my name, but will
allow almost anything else. I have other cells that have silmilar
problems
with other data. These cells did have validations in place which were
removed. But I did a Clear ALL on the cells in question and even used the
validation command to "accept any value" but nothing I try works. Anyone
have any suggestions on how to clear this problem?