Text is changed to current date date when row is selected. No idea why?

Hello all,

I have been creating a workbook for my daughter to record sales info. I finished it yesterday and sent it to her as an email attachment.

One of the sheets has order numbers (eg. BB001, BB002 etc.) in column A, and the cells are formatted as TEXT. The problem I have is that when she clicks on a Row Number, say to highlight the whole row, or to insert a new row, the Order Number immediately changes to a the Current Date.

I have no idea why this is happening as we are both using Excel 2007 and this error does not occur on the original workbook which is saved on my computer.

As I don't know what is causing the problem, I am struggling to research the issue in order to find a solution.

Any assistance would be graciously appreciated.

Rob.

Hi Martin,

Thank you for your speedy response. I fear I may not have explained myself adequately, sorry.

I am not trying to automate anything, in fact I need to stop an unknown automatic error. The changeover from a number to a date is happening all by itself, but only on the workbook 'copy' that I emailed to my daughter. As such I am unable to upload even a pretend sheet that will show the error occuring.

I'll contact my daughter, and get her to email her copy back to me. Maybe the error will carry with it. If it does, I'll be able to do as you request.

Thank you thus far.

Rob

Hello again martin,

Ok, can't get hold of my daughter at the moment, so I have made a mockup workbook which describes the issue.

Hope this helps,

Rob

Hi Martin,

I've looked though the original workbook; cell formats, table formats, VBA codes, formulas, and I can't find
anything unusual, although as I said, I'm not exactly sure I know what to look for. Anyway, I guess you are probably correct.
I'll do as you suggest and I'll feed back the results.

Thank you for your input,

Rob

Hi Martin,

I am afraid to report that to my severe embarrassment, I have discovered that the issue was with a VBA code within the original workbook. I recalled that when I first set about creating it, I remember researching automatic data input, and I remember looking at some VBA code and trying it out, but did not have much success with it, simply due to the fact that I was not quite sure how to use it.

I have discovered that when the workbook is opened, a notification to enable Macros appears. The DATE issue causing rise to this thread is initiated when Macros are enabled, so I had another look round with the VB editor, and found it. I have obviously neglected to delete the code.

I have now deleted it from the original workbook and the problem has gone, Unfortunately, I neglected to copy it, to include in this message beforehand (I fear you may have had some small interest in seeing it, if only for future reference), sorry about that too.

I assume at this time that my daughter either selects 'Enable Macros' via the same prompt, or has her Macro security settings set to allow them. Either way, I am confident now that I can resolve the issue.

That said, I would like to thank you very much for your input, and would ask that you accept my apologies for any inconvenience caused.

Best regards

Rob