TheBoy's mail has put a smile on my face, thank you so much as I've the same setup (with telemactics etc), so I've got some hope now..
I don't think my NCDR1500 came with any code, the reason is that I've disconnected it several times and changed battery etc, but it has never asked me for a code. It just works fine when I put it back even after a month. I will still take a look in the books but I very much doubt that I've a code for it.
The CDC3, on the other hand was bought "brand new in sealed box" from Vauxhall dealership who ran a clearance on fleebay (hence the part number 91157147), so it would be upsetting to find that the laser is knackered. It did come with a code but the headunit/ display never asked for it..
I could not find a way to update my profile any further but I shall look again. I am in Basildon, Essex and travel regularly to Birmingham on weekends..
Thanks once again TheBoy, I hope you would get me sorted...
Oh dear, now time to take the smile off your face

The NCDR1500 does indeed have a code. Its not a traditional code in the sense of one that needs to be input after battery disconnection, but a pairing code.
The Infotainment devices - NCDR, display, CD Changer and Telematics - are all paired to each other at time of install. The idea being that if one of the items is removed, it can't be used elsewhere, as it hasn't been depaired from its partners (its not as entirely clear-cut as that, but thats the principle).
To replace faulty components, assuming that the faulty component is too faulty to allow the other components to be depaired from it, you need to replace the faulty component with one in 'Delivery State' (ie, unpaired), and pair it to the other components
using the original pairing code of the other components.
If this original pairing code is unknown, you have a big problem, as we have yet to devise a way to depair the NCDR1x00 or the telematics units.
Do you have the original CDC3 that was fitted to the car, or wasn't one fitted?