Shrinking List Box???

[Jamm_027]

Alright I know this is not a very specific question but I am not sure where to begin.

I have a workbook that I original created in Excel '03. That is currently used at over 200 locations in my company. Everything has worked perfect for several years. It worked fine in excel '03 and '07 but now that I have a few users that are in excel '10. Excel '10 seems to be causing a problem with a macro that I can't figure out.

The employee enters data into 4 columns on a sheet and then clicks a command button. When the macro runs it distributes the data accordingly to different places. The problem is with 2 "List Boxes" on the sheet. Each time the command button is clicked and the macro runs. The boxes actually shrink in size. After 5 or 6 entries they are so small you can not read the list inside. To fix, I simply unprotect the sheet and re-size the box. But it continues to happen.

Again, this problem is only in Excel '10. Is there some simple change with '10 that would be causing this? Not sure where to begin? Any ideas would be greatly appreciated. I can post my code if needed.

thanks,

jam

 

[Ruddles]

This exact same thing happened to one of my workbooks a while ago: it worked fine on my machine but when it was rolled out to users, the comboboxes would shrink slightly every time the workbook was opened until eventually they were like The Incredible Shrinking Man!

After I ruled out radiation and insecticide, I came to the conclusion that it was something to do with screen resolutions because the guys who were using the same hardware as me weren't experiencing the problem whilst the guys using laptops were experiencing it the worst of all. (I found it hard to believe but it was the only thing I could think of.)

Eventually I cured it by resizing the comboboxes in the Workbook_Open event so they were always a sensible size.