ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   On open, resize page (https://www.excelbanter.com/excel-programming/339528-open-resize-page.html)

Daniel Bonallack

On open, resize page
 
I have an application that fits on my screen perfectly at 100%, but not on my
colleague's screen, as her settings are at 1024 x 768, and mine are set to
fit more on the page.

Is there a way for this application to check the user screen properties, and
drop the page to 90% if the settings are 1024 x 768 (and to 75% if 800 x 600)?

Thanks in advance
Daniel

Norman Jones

On open, resize page
 
Hi Daniel,

See MSKB article # 148395:

'How to Determine the Current screen Resolution (95/97)'

http://support.microsoft.com/?id=148395



---
Regards,
Norman



"Daniel Bonallack" wrote in
message ...
I have an application that fits on my screen perfectly at 100%, but not on
my
colleague's screen, as her settings are at 1024 x 768, and mine are set to
fit more on the page.

Is there a way for this application to check the user screen properties,
and
drop the page to 90% if the settings are 1024 x 768 (and to 75% if 800 x
600)?

Thanks in advance
Daniel





All times are GMT +1. The time now is 12:20 AM.

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