I have this excel worksheet that includes several User Form windows. One of them is larger in size. When it opens, it should fit the display screen but for some reasons, I have an environment that kind of streched the User Form Window (only the user form) to a point we cannot reach the OK button I created at the buttom of the User form.



This spreadsheet works perfectly on Excel 2003, 2007 but this unique user with a Toshiba Satellite, Win 7 and Office 2010 (Excel 2010), this phenomenom happens.

I have tested the same file on a different PCs with Office 2010 (Excel 2010) and it is working perfectly.


We have installed the newest Display driver but this is still happening.

Anyone has an idea of what is going on ?


Thank you

Pierre

Hi Pierre,

That suggests the problem PC is running a quite a low resolution. Since the userform works in pixels, the count of pixels is too many to fit and the rest doesn't show. Accordingly check your display resolution - it should probably be around 1200*800 - 1360*768. You can do this check by right-clicking on the Desktop and choosing 'Screen resolution'.

PS: I'm typing this on a Toshiba Satellite, Win 7 and Office 2010 (Excel 2010).

__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]

Hi Paul,
thank you for your rerply.

Actually, the resolution is at 1360*768 already. We tried different resolutions without helping the problem.

What is the model of your Toshiba Satellite and what brand is the display card ?

The machine causing the problem is a model A650 and has an Intel Graphic card.

Mine's an A500, with a NVidia graphics card @ 1366*768 - not that that should matter.

__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]