I need to see your code. Can you attach your file? It is possible that your code is doing something that you are not expecting it to do.

Also, take what you described in your last post and provide enough detail so that I can reproduce those exact actions on your file, so I can see exactly the same behavior that you are seeing. Include how you protected the sheet, exactly what cells you are pasting data into, and your "Paste Special" sequence (there are many options under Paste Special).