Fit picture to screen

[Giordano Bruno]

I have an image called Picture1 and I want it to fit the size of any screen. The aspect ratio is > 2:1 so I guess that some of the right hand side of the picture will not be visible. I can get the screen size and also the picture size, but when I try to adjust them, the calculation doesn't stack up.

Selection.ShapeRange.Width give the width of the picture as 1120. GetSystemMetrics (SM_CXSCREEN) gives the width of the screen as 2736 yet the picture is larger than the screen. Does anyone have an explanation?

 

[GTO]

I have an image called Picture1 and I want it to fit the size of any screen...

...I can get the screen size and also the picture size,...

I may be wrong for presuming this, but are we talking about an image plunked/embedded onto a worksheet? If so, what window are we measuring to see how big the picture should be? Are we assuming that the worksheet/workbook and application's main window are maximized?

...Selection.ShapeRange.Width give the width of the picture as 1120. GetSystemMetrics (SM_CXSCREEN) gives the width of the screen as 2736 yet the picture is larger than the screen. Does anyone have an explanation?

Selection.ShapeRange.Width returns in Points; GetSystemMetrics (SM_CXSCREEN) returns the Width in Pixels.

 

[Giordano Bruno]

Hi GTO. Yes, the image exists on the workbook and the excel sheet window is maximized. Note that this is not a small difference .

The problem is complicated by the need to move the image after it has been resized as I have another image that needs to be centred on the screen, but one thing at a time.

 

[Giordano Bruno]

...and what units have I measured the picture in. And how do I convert them. It's starting to sound difficult.