Screen Sizes (and moving across screens)

Good afternoon all,

We have a sheet that needs (ideally) to be displayed in full on screen. Most of the users are now using a Surface Pro linked to dual monitors (both monitors are the same size & resolution) therefore they may open the sheet on any of the 3 screens and potentially move it from one to another.

I have basic code to identify the screen resolution which I figured I could just run whenever the sheet is activated to resize and move items to get them on screen.

trouble is, it appears all 3 screens are set to 1680 x 1050 but the Surface Pro is set to change the size of text, apps etc by 225%.

Is there anyway to return that data in order to take it into account?

(oh and this is being used by numerous users who may all have their monitors/ Surface set to different settings.)

Hi,

If you are trying to make a specific range fit on screen, all you need do is select it and then run

Please Login or Register  to view this content.

Ok so that is pure genius.

Next stage, is it possible to run that automatically on the workbook moving screens? ie if a user opens it on the Surface and then drags it to one of the monitors or vice versa?

Im guessing not and its no great hardship to just include it in the worksheet select so users reclick the sheet to resize but it would be nice...

It could probably be done with a lot of API code to set up mouse hooks and whatnot, but more trouble than it's worth I would suggest.

I'm not even going to bother trying then

Many Thanks for the help