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


--
Lil Pun
------------------------------------------------------------------------
Lil Pun's Profile: http://www.excelforum.com/member.php...o&userid=33840
View this thread: http://www.excelforum.com/showthread...hreadid=536497