Solved

Excel Activex controls act strange when projected

Posted on 2013-10-31
5
673 Views
Last Modified: 2013-10-31
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.
0
Comment
Question by:Rich5150
  • 3
  • 2
5 Comments
 
LVL 12

Expert Comment

by:Harry Lee
ID: 39615018
Rich5150,

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.
0
 

Author Comment

by:Rich5150
ID: 39615481
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?
0
 

Author Comment

by:Rich5150
ID: 39615515
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.
0
 
LVL 12

Accepted Solution

by:
Harry Lee earned 500 total points
ID: 39615530
Yes, I believe you have to install the patches on every single machines that is going to use the spreadsheet. At least that's what I have to do on all the machines that have Excel 2010 running in my office here.

Honestly, I have no idea why Microsoft wants users to request for these patches instead of having it available to the public just like most of the patches. Maybe the patch can do some harm in another way.
I also have no idea why all these ActiveX patches is created one by one, on an individual issue basis instead of one ActiveX bug fix patch.

I personally believe Microsoft should make these fixes a part of the standard Windows Update or Office Update patch.

One thing I know for sure, these ActiveX control object bugs are super annoying.

So far that's the only way I found that can fix the issues. I hope it helps you.
0
 

Author Closing Comment

by:Rich5150
ID: 39615546
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.
0

Featured Post

Threat Intelligence Starter Resources

Integrating threat intelligence can be challenging, and not all companies are ready. These resources can help you build awareness and prepare for defense.

Join & Write a Comment

This is pretty cool.  The purpose of this VB Script is to help you document where JAR (Java ARchive) files and specifically java class files are located so that you can address issues seen with a client or that you can speak intelligently with a dev…
Not long ago I saw a question in the VB Script forum that I thought would not take much time. You can read that question (Question ID  (http://www.experts-exchange.com/Programming/Languages/Visual_Basic/VB_Script/Q_28455246.html)28455246) Here (http…
The viewer will learn how to simulate a series of sales calls dependent on a single skill level and learn how to simulate a series of sales calls dependent on two skill levels. Simulating Independent Sales Calls: Enter .75 into cell C2 – “skill leve…
Graphs within dashboards are meant to be dynamic, representing data from a period of time that will change each time the dashboard is updated with new data. Rather than update each graph to point to a different set within a static set of data, t…

760 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

21 Experts available now in Live!

Get 1:1 Help Now