Solved

Excel Active X Control losing shape, size, font

Posted on 2010-09-15
3
769 Views
Last Modified: 2013-12-25
Sorry if this is a dumb question.

I am running office 2010.
Have the MS treeview control loaded on a worksheet, not a form.

Everytime I open the sheet it loses it's size, font and items.  I can scroll up and down and it comes right back.  I don't have anything else running in either workbook or sheet load.

My sheet is at 100% zoom.  I thought the listbox did something wierd like this and could be fixed with intregal height but...

Any help?

Thanks experts.
0
Comment
Question by:skillilea
3 Comments
 
LVL 11

Accepted Solution

by:
jkpieterse earned 250 total points
ID: 33689098
Did you use 2010 to create the workbook?

In my experience, ActiveX controls do not play well with Excel (and it is worse with 2007, 2010).

Note, that in Office 2010 64 bit you will not be able to use 32 bit third party activeX controls at all, they require a 64 bit version of those controls.
0
 
LVL 17

Assisted Solution

by:Shanmuga Sundaram
Shanmuga Sundaram earned 250 total points
ID: 33690285
check whether this link helps you

http://spreadsheetpage.com/index.php/tip/using_controls_on_worksheets/

Also could you please let us know if you have the same issue even in other versions of office?
0
 

Author Comment

by:skillilea
ID: 33715864
You can award the points
0

Featured Post

Is Your Active Directory as Secure as You Think?

More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.

Question has a verified solution.

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

Suggested Solutions

Title # Comments Views Activity
adding to,subject,body for the opened mail instead of creating new mail 15 31
Hiding column macro 10 28
ms office troubleshooting for users 8 34
ADD New Entries 7 15
When trying to find the cause of a problem in VBA or VB6 it's often valuable to know what procedures were executed prior to the error. You can use the Call Stack for that but it is often inadequate because it may show procedures you aren't intereste…
This tutorial explains how to create a series of drop-down lists that are dependent upon prior selections to guide (“force”) the user to make the correct selection and reduce data errors within Microsoft Excel. Excel 2010 was used for this tutorial;…
The viewer will learn how to simulate a series of coin tosses with the rand() function and learn how to make these “tosses” depend on a predetermined probability. Flipping Coins in Excel: Enter =RAND() into cell A2: Recalculate the random variable…
This Micro Tutorial demonstrate the bugs in Microsoft Excel for Mac with Pivot Charts.

914 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

12 Experts available now in Live!

Get 1:1 Help Now