Form elements change size with Screen Resolution change

A

Amon.Noreinor

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Publisher 2019 Format Picture window size too large to display OK button 0
Working outlook via vba code with xlsx - error 0
VBA word change keys 0
Embedded Excel into Word with Tables 0
Excel does not accept text format! 0
Template with fields and premade texts.. 0
Excel freezing after sharing document by Email 0
Cannot Change Back to Previous Settings After Clicking "Try the new Outlook" 0

Top