Macro acting funny

[ChesterJ]

Hi,

I have a macro that imports a text file, cleans it up, and transfers the information to a printable data sheet for processing. It works great for %99.9 of my users.

I have one guy who just transferred from excel '14 to '07 (which is the format my software is formatted for). When he runs the program, the macro starts off by importing the text file, reading how many lines it needs on the data sheet, then calls another routine to insert lines accordingly before transferring the data.

When his computer gets to this routine, it unlocks the data sheet, adds some random lines where it is not told to do so, and colors some of them green. Nothing in the code says to add lines in this area or even change color. It even removes all formatting.

Sifting through the code, the macro does all this on one arbitrary piece of code {ie. Sheet1.(Cell(info1) = Sheet2.(Cell(info2)}.

What is causing this? My first guess that is there is something going on with his recent conversion to Excel 2007 from 2014. Caches, residual settings, etc.

I cannot post the code as it is proprietary information.

Any information would be great.

Thanks in advance!

 

[ChesterJ]

Additionally, I should add that this form is maintained on a company server and is strictly revision controlled. It is sheet and project protected. A user must retrieve a master copy of this form from the server prior to use.