Advice re resizing excel in full screen mode according to user's set up (screen resolution, monitor size etc); also puzzled re pixel count

Viewed 13

I am trying to understand pixels/points per pixel/screen resolution etc so I can detect a users set up (screen resolution/monitor size etc) and adjust my app so it looks as it should on all screens, and am looking for advice on what seems like quite a daunting task..

I am aware there are a number of ways of doing this, for example I could resize all my controls according to the aforementioned data etc. but (subject to testing), I am thinking that Zoom may be the best and easiest way of doing it.

To give a bit more info, my app is excel and will be distributed as an add-in.

I have decided to not use excel's ribbon, but to mimic it with a round cornered, borderless user form as it gives me more freedom and loses all the scenery at the top of the screen without having to use a load of API code (I am a strong believer that simpler is better and don't like using code I don't understand).

I am also going to set excel to full screen and hide the task bar, so to get maximum screen for the charts and data to be displayed. On exit it will go to normal screen and the task bar restored to its previous state.

Be very grateful for wiser (if not older!), experienced programmers wisdom on potential things to look out for and the easiest way to accomplish this (is Zooming the best wya as I'm thinking in your opinion).

Thanks in advance for your help, Mark

0 Answers
Related