VBA ActiveX controls grow in size over Remote Desktop Connection

Posted by Alistair Knock on Stack Overflow See other posts from Stack Overflow or by Alistair Knock
Published on 2010-03-09T11:52:18Z Indexed on 2010/03/15 15:19 UTC
Read the original article Hit count: 942

Filed under:
|
|
|

We have an Excel workbook with a number of ActiveX controls, running in Excel 2003 on Windows XP. When connecting using Remote Desktop, the ActiveX controls change font, sometimes font size, and sometimes orientation (in the case of a spinner control). This happens on first connection and also as the workbook is used - some of the controls then enlarge in size, often overlapping other controls and part of the workbook.

I read somewhere this may be caused by improper connection management (not closing them) leading to increasing memory usage; are there other reasons why the display is so different over Remote Desktop and are there workarounds? (the properties of each control usually remain the same, so force-resizing them doesn't always have an effect)

© Stack Overflow or respective owner

Related posts about vba

Related posts about excel