Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Resizing cells in a selection without resizing entire sheet | Excel Discussion (Misc queries) | |||
Need to convert point on screen to various screen resolutions | Excel Discussion (Misc queries) | |||
Making GIFs from anything, with optional resizing | Excel Programming | |||
different screen resolutions | Excel Programming | |||
Exporting Charts as GIFs | Excel Programming |