View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Charles Jordan Charles Jordan is offline
external usenet poster
 
Posts: 56
Default 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