Want to win a PS4? Go Premium and enter to win our High-Tech Treats giveaway. Enter to Win

x
?
Solved

Excel Activex controls act strange when projected

Posted on 2013-10-31
5
Medium Priority
?
713 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
[X]
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
  • 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 2000 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

Independent Software Vendors: We Want Your Opinion

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Question has a verified solution.

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

This article will guide you to convert a grid from a picture into Excel format using Microsoft OneNote and no other 3rd party application.
After seeing numerous questions for Dynamic Data Validation I notice that most have used Visual Basic to solve the problem. This suggestion is purely formula based and can be used in multiple rows.
This Micro Tutorial demonstrates how to create Excel charts: column, area, line, bar, and scatter charts. Formatting tips are provided as well.
This Micro Tutorial demonstrate the bugs in Microsoft Excel for Mac with Pivot Charts.

597 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