Excel 2007 combo box and shared workbook

[thart21]

I have a workbook with 3 combo boxes.

ActiveX control? (=EMBED("Forms.ComboBox.1","") They are filled using named ranges on another worksheet and work fine. The problem happens when I share the workbook the combo boxes become completely non-functional. They don't even drop down when clicked.

Anyone experience this same issue? I've looked at everything I can find about issues in 2007 but could not find this problem.

Thanks,

Toni