Cell in Excel spreadsheet will not accept entry of specific data v TimK 26.09.2006 21:48:01 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?

Re: Cell in Excel spreadsheet will not accept entry of specific data v "Ronald Dodge" <ronald.dodge[ at ]cfgraphics.com> 26.09.2006 22:13:11 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" <TimK[ at ]discussions.microsoft.com> wrote in message news:3D06D8A2-251F-4C7D-9154-3C5FBD738698[ at ]microsoft.com... [Quoted Text] > 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?

Re: Cell in Excel spreadsheet will not accept entry of specific da TimK 26.09.2006 22:50:01 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: [Quoted Text] > 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" <TimK[ at ]discussions.microsoft.com> wrote in message > news:3D06D8A2-251F-4C7D-9154-3C5FBD738698[ at ]microsoft.com... > > 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? > > >

Re: Cell in Excel spreadsheet will not accept entry of specific da "Ronald Dodge" <ronald.dodge[ at ]cfgraphics.com> 27.09.2006 15:23:44 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" <TimK[ at ]discussions.microsoft.com> wrote in message news:A530F517-E541-499C-8436-FB0962D6357E[ at ]microsoft.com... [Quoted Text] > 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" <TimK[ at ]discussions.microsoft.com> wrote in message > > news:3D06D8A2-251F-4C7D-9154-3C5FBD738698[ at ]microsoft.com... > > > 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? > > > > > >