ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Form elements change size with Screen Resolution change (https://www.excelbanter.com/excel-programming/381854-form-elements-change-size-screen-resolution-change.html)

[email protected]

Form elements change size with Screen Resolution change
 
I have an Excel 2000 workbook. I have a couple of listboxes and
textboxes from the VB Control toolbox on it.

My problem is that when I use the file on another computer with a
different resolution the form elements randomly change size when I open
the Excel file. Also when I click on the controls or add data to them
they resize on the fly.

I do not know whats causing this. I have set Autosize and
IntegralHeight to false during design time, but even that does not
solve the problem. I have protected the worksheet but it does not solve
the problem.

If anyone has any idea about this, please let me know



All times are GMT +1. The time now is 09:46 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com