Macros Stopped Working on One Computer "Cant Exit Design Mode Because Control..."

Hi All,

I am having a really frustrating time figuring out what's going on here so i'm hoping that someone else might be able to help.

I've created an excel file that has quite a bit of VBA in it. Everything works fine until the guy I work with opens the file on his computer (via the network). Once he opens and saves the file, the macros/buttons no longer work on my computer and I get the following error:

"Can't exit design mode because Control cannot be created."

Everything still works fine on his computer (and everyone else in the office) but not on mine.

The file is a template that we use for every project we get. We have the same problem with each project-specific file, not just one.

I've tried installing the Microsoft hot fix for activex controls that was released a while back, but that didnt work. The trust center settings all look fine. I've tried everything I can think of, but I haven't had any luck.

Has anyone else come across this? I really need to get this fixed.

Thanks for your suggestion.

It doesn't look like it. Would it say "missing" in the name?

Out of the long list of available references, only the top 5 are checked.

Originally Posted by buran

Yes, it would say MISSING: in front of the name.



It always show the reference for the current project (checked ones) at the top.
My guess was that your colleague is using higher version of some library, and it's missing on your computer, but if it doesn't say so I don't have other ideas...

Nope. Nothing says "missing." I checked the other computers that it works fine on and they have the same references checked and nothing that says "missing" as well.

Any other ideas.

Originally Posted by karedog

Hi,

From your user panel, you mention that you used Excel 2003 version.
Do your colleagues use higher Excel version (2007++) ?
If so, then ask one of them to open the file and resave the file using :
Save as --> Excel 97-2003 Workbook


Regards

Sorry about that. I am actually on Excel 2010 at work. Everyone else is also on 2010, tough the versions differ. Some use version 14 and some use 15.

Sorry about that. I am actually on Excel 2010 at work. Everyone else is also on 2010, tough the versions differ. Some use version 14 and some use 15.

This is the problem. If you are using 14, and they save the file as a 15, you can't open the file the same way. Try asking them to save as 14 or less.

For anyone else who has this issue, I fixed it. It turns out that whoever had this computer before me turned off automatic windows updates. So, after downloading a few years worth of updates everything started working again. My excel still shows version 14.0.xxxxx so im not sure if it was an excel update or something else, but one of them fixed theissue.

Thanks for all of your help and suggestions.

I gave it a shot... still had the same issue on the older version though.

Its strange that im having this issue on the computer that created the file, but everyone else doesn't have an issue. Something has to be different in the settings/version, but I cant find what it is.