Excel Combo Boxes

[allepa]

Hi,
How do I go about copying combo boxes to a number of different cells ?

I have one combo box that is linked to another worksheet, but when copying, it copies the original details, so, when changing one, it changes all. The only solution I have is to change the format control for each box, but, as I have quite a number of boxes, this seems like a long winded way of doing it. Does anyone have a faster way ?
Also, how to I lock the combo box to a particular cell ?

Thanks for helping out.