sounds like your constant power is connected (cd will eject, even with the key out) and that red wire goes to a power source that is only "hot" when the key is on... try running it to the sunroof fuse on the passenger side with a temporary wire, and see if that works... if it does you can leave it there, or tap into a wire from the ignition that is "hot" with the key on.
|