Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people, just like you, are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
Solved

Excel Activex controls act strange when projected

Posted on 2013-10-31
5
688 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

Networking for the Cloud Era

Join Microsoft and Riverbed for a discussion and demonstration of enhancements to SteelConnect:
-One-click orchestration and cloud connectivity in Azure environments
-Tight integration of SD-WAN and WAN optimization capabilities
-Scalability and resiliency equal to a data center

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

If you need to start windows update installation remotely or as a scheduled task you will find this very helpful.
With User Account Control (UAC) enabled in Windows 7, one needs to open an elevated Command Prompt in order to run scripts under administrative privileges. Although the elevated Command Prompt accomplishes the task, the question How to run as script…
The viewer will learn how to use a discrete random variable to simulate the return on an investment over a period of years, create a Monte Carlo simulation using the discrete random variable, and create a graph to represent the possible returns over…
Finds all prime numbers in a range requested and places them in a public primes() array. I've demostrated a template size of 30 (2 * 3 * 5) but larger templates can be built such 210  (2 * 3 * 5 * 7) or 2310  (2 * 3 * 5 * 7 * 11). The larger templa…

856 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