Sizing a Picture (a .gif) to fill a worksheet, for any resolution
What is the best way of sizing a Gif picture to fit to the borders of
a worksheet (a splashscreen) having first tested for its .Usablewidth
and .Usableheight ??
(We tried inserting it at a screen resolution of 1,280 x 1,024 and
found that it needs to be of width 1,890, but we clearly need it to
test for any resolution, and then resize dynamically. We know the
address of the bottom right cell, (applicable in all cases), and we
can zoom the screen to fit, but what is the best way of then filling
it with a gif programmatically , please ?
Charles Jordan
|