Worksheet stopped working.

I need help trying to find out why this worksheet stopped working without any changes made intentionally . I have run the debug and checked the code but I can't seem to find what is stopping the program from running. The code is too long to list here, the system won't let me show it here. The code is in the workbook on the first page ("Sign_In"). All help is greatly appreciated!!!!

Norie,

The worksheet stopped entering the items listed in each If Then for the Target.Value input by user (ie ATR, AV, CO, etc.). I did run the debug several times without errors showing up. That's why I am asking for the help. I will run it again though when I get home.

Winon,
The CAP_PD_Deposit is another worksheet I did not include because it does nothing during this process.

1. Same as above, something is wrong with 'End If' and the same with the logical structure.
A. Why in segment:

Please Login or Register  to view this content.

'End If' is blocked ?

B. It seems that there are two 'End If' for the 'AV' segment.
C. Two 'End If' at the end are free/single.

2. Why below:

Please Login or Register  to view this content.

are not 'Const' ?
These "values" surely/certainly do not change.

3. Why below:

Please Login or Register  to view this content.

is in the middle (before 'Select Case Target.Column') and at the beginning is blocked ?

4. Just in case, run (in Immediate window) 'Application.EnableEvents = True' property before running the macro.

Thanks to all,
Norie, Winon, porucha vevrku, TMS
I am new to VBA as you can tell from my code and post. You all got me headed in the right direction although I still am not getting the "End If" error reporting but I have separated my combination of code (multiple If Then's) and have most of the code working. I am still working on separating the If Then's. I was trying to shorten up and speed up my code by combining them which seems to have been my problem. The double Dim statements I tried because I could not get code working and I though maybe the Const was not flowing through to that sheet. Could some one explain how to do the suggestion of: 4. Just in case, run (in Immediate window) 'Application.EnableEvents = True' property before running the macro, by porucha vevrku. Also the rem outs were to see if I could get things going.
The

Please Login or Register  to view this content.

was from some of the help I had received from other people that I did not know if that was causing the problem of not being able to find errors in the debug. I have had several helpers that included the error checking that I did not understand and was afraid to remove it.
I will post a copy of my completed sheet after I get it all working. I did try to download the workbook from Winon but the "red sheet1" link would not work. Thanks again for all the help and please check back on me in a few days as I hope to finish.
Thanks for all the help!! To be continued...

Sorry it took me so long to get back on, this but I had issues that took me away from the net.
I have looked at your text file and the answers to why all the End If of Missing End If is that I have been using parts of others code and don't really understand all they have included. I use the debug and if it tells me I need an end if then I put it in. I am trying to learn this out of some VBA books I have found. I have gotten my code to run with the help you all have given me. I have tried to follow what I see in code structure for the staggered If and End If and didn't know there was a better structure to follow. I do get lost if all the If's sometimes.

I thank you all for all your help!!