Excel 2010 Can't exit design mode because Control 'combobox1' can not be created.

[furstukin]

We have a macro spreadsheet that has worked just fine for quite awhile before I started working here. However the computer I was given has Windows 7 and Office 2010 installed on it where as everyone else is using Office 2007 and Windows Vista. So when I try to open the spreadsheet it comes up fine but as soon as I try to change tabs or hit a macro button I get the following message "Can not exit design mode because Control 'combobox1' can not be created." No one else has ever gotten this error and I can not find a clear reason why it is happening to me. From the research I have done I learned it is a problem with the ActiveX controls but is there a simple fix for that?

The other interesting thing is I have looked at the code and ther is only one userform and it does not have any Combo Boxes in it at all so I am really wondering why it is telling me combobox1 can not be created.

Has anyone else run into something like this before? Any help is greatly appreciated.

 

[RoryA]

What are your ActiveX settings in the Trust Center in Excel Options?

 

[furstukin]

What are your ActiveX settings in the Trust Center in Excel Options?

I set it to the un-recommended "Enable all with out restriction and with out prompting" and it did not help.

 

[RoryA]

Is your copy of 2010 a full install including VBA? Can you record and run macros in other workbooks?
There do seem to be a few issues with 2010 and ActiveX controls on worksheets, which I suspect is what you have, but I'd like to rule out the obvious stuff first.

 

[furstukin]

Is your copy of 2010 a full install including VBA? Can you record and run macros in other workbooks?
There do seem to be a few issues with 2010 and ActiveX controls on worksheets, which I suspect is what you have, but I'd like to rule out the obvious stuff first.

Yeah I have been running and writing macros on this computer since I started this position 6 weeks ago. And I use ActiveX controls in my own macros so I am really at a loss as to why this one workbook wont work for me but it works fine for my supervisor and area manager both. Again any suggestions are greatly appreciated.

 

[RoryA]

Can you email or post the file somewhere (you can remove all data from it)?

 

[furstukin]

Can you email or post the file somewhere (you can remove all data from it)?

I removed all information that can identify what or who the data is for and removed all links to files and replaced them as a C:\ in the macro code.

Here is a link to the file http://members.cox.net/dabloomquist/Weekly Summary No Data.zip

 

[RoryA]

I am unable to extract the workbook from that zip file - Windows keeps reporting an error. Do you have an unzipped copy?

 

[furstukin]

I am unable to extract the workbook from that zip file - Windows keeps reporting an error. Do you have an unzipped copy?

Yeah but everytime I treid to upload the macro enabled workbook it broke it down into compnent files treating it like a zip file... let me try to rezip and stop the error. I got the same one when I tried to open it from the internet.

 

[furstukin]

Yeah but everytime I treid to upload the macro enabled workbook it broke it down into compnent files treating it like a zip file... let me try to rezip and stop the error. I got the same one when I tried to open it from the internet.

Ok it should work now. The link is the same. And as long as I save the zip folder to my HDD then try to open it it will open fine. But if I just try to open the zip from the net then open the excel file it says some data needs to be recovered...this file has shown me so many errors I have never seen lol