View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Charles Jordan Charles Jordan is offline
external usenet poster
 
Posts: 56
Default Resizing BackgroundPicture Gifs programmatically for varying screen resolutions

We have 20 workbooks, all of which have a background picture for
Sheet1. The problem is that we get *tiling* for any resolution
different from 1,024 x 768. The obvious solution is to test for the
user's screen resolution and import an appropriately sized Gif, which
means for say 10 resolutions, 10 gifs ..... times 20 workbooks.

Instead, what about inserting a master Gif into a holding worksheet,
testing for screen resolution, and resizing it appropriately. But,
even if we could do this resizing, the following code which is
supposed to then set the background picture, bombs with the error msg
"Picture does not have value property"

Worksheets("Sheet1").SetBackgroundPicture
Worksheets("Sheet4").Pictures("Picture 1")

Is there any solution to this ? Or any other way of using one master
Gif ?

TIA - Charles Jordan