Cell in Excel spreadsheet will not accept entry of specific data v
 

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?

Cell in Excel spreadsheet will not accept entry of specific data v
 

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?

Cell in Excel spreadsheet will not accept entry of specific da
 

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?

Cell in Excel spreadsheet will not accept entry of specific da
 

From the spreadsheet side, have you tried temporarily disabling the
execution of macros by bringing up the Visual Basic Editor toolbar and click
on the design button so as it's pressed down, then try to enter your name in
those particular cells? By doing this, we can with a high probability
narrow it down to either just the VBA side or just the spreadsheet side.

The only other thing that I could possibly think of is that if you have a
range name and a public function by the same name, that could potentially
create a problem.

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

"TimK" wrote in message
...
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?