Excel Activex controls act strange when projected
I recently began using activex controls because of the additional formatting I can do that isn't possible with form controls. I went to demo this file for a client, so we had my computer plugged into a projector. During the demo, I selected an activex dropdown to change the selection, and clicking on it caused the entire dropdown control to get larger, and continuing to click on it would cause it to increase in size each time, to the point where you couldn't see anything else on the screen. It was totally bizarre. I have only witnessed this behavior when my computer was connected to a projector. The controls all work perfectly when I am not connected to a projector. Has anyone else had this problem, and if so, what did you do about it? I really don't want to go back to using form controls. Thanks.
ASKER
If this fix prevents this from occurring on my computer, that's great, but I have to distribute this file once I've finished putting it together. Are the other users going to have the same issue?
ASKER
Thanks for the suggestion on getting additional info. Read through quite a bit of stuff, and the primary conclusion I've come to is to not use activex controls. I certainly don't need people contacting me months from now telling me that their file is acting weird. So unless someone has come up with a permanent solution that will allow me to distribute this file and keep others from having this problem, I guess I'll be going back to using form controls in the worksheets, or building userforms if I want to use activex controls.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Thanks for your help. Couldn't agree more with everything you said regarding Microsoft. If the stupid things are that problematic, they should make a fix available to everyone, or remove the ability to put them into worksheets. Sometimes I wonder what the folks at Microsoft are drinking.
That's a commonly known issue of ActiveX control in Excel. They like to resize themselves from time to time.
Please take a look at this Microsoft Technet document. It addresses some of the issues and provided some fixes.
ActiveX and form controls resize themselves when clicked or doing a print preview
I suggest you to search "Excel ActiveX Control Prevent Resizing". There are way too many component that need to be fixed, and it is hard for me to list out all of them here.