The Control Named X does not support saving?

[asystole0]

Hi

I have a peice of code which pulls in all the tabs from another workbook including named ranges.

This works fine and i had some help here from XLD stopping lots of prompts opening when importing these ranges here http://www.vbaexpress.com/forum/showthread.php?t=32592

After re vistiting this is seems that when i try to save the work book i get the following message:

"Microsoft office excel cannot save this workbook because control name 'labour1' does not support saving, to save the workbook delete the control and then try the save again"

I dont want to remove the control I need it!

Any help greatly apreciated, thanks

[austenr]

what control type is 'labour1'?

[asystole0]

Sorry its a named range called "labour1"

[asystole0]

Any ideas on this one? I just dont understand why it wont save once the named ranges have been imported!

[mikerickson]

What is the refers to for labour1?

[asystole0]

What is the refers to for labour1?

i was wrong, i have a named range called labour rates and have mistaken that for Labour1!

in that case im not sure what Labour1 or what it refers to? Can you help or explain what it might be?

[asystole0]

i was wrong, i have a named range called labour rates and have mistaken that for Labour1!

in that case im not sure what Labour1 or what it refers to? Can you help or explain what it might be?

Ok I found "labour1" its a combo box embeded on the worksheet, i need them to stay in place, any ideas now?!!