I have setup an Excell file for data entry. The entry starts at cell A2 and when data is entered it goes down from there and if data does not match the data in cell A2 it is moved to colum B in the corresponding cell. If a 1 is entered into an cell in column A, the active cell moves to cell C2 and when data is entered there the file saves automatically and reopens.

A 2nd party is going to have to add their own macros to this file/project and they did this in Module 2, the only problem is it looks unfamiliar to me and I noticed they are using DDE (Dynamic Data Exchange) which I have no experience using at all and I am not sure of some other things in their module either. I think it is trying to link to software pieces together but I am not sure.

The problem is when they run the software, and enter data and save, the blank form comes up but the active cell is not A2 which is what it is supposed to be after a save a reopen. The active cell is the last cell data was entered in. Can somebody look at this file and tell me what would cause that and how to fix it? There is a download link below, thanks for any assistance.


http://www.rapidsharing.com/53ecb617...4ce06cec20090a