Resizing BackgroundPicture Gifs programmatically for varying screen resolutions
"Bill Renaud" wrote in message ...
I believe tiling occurs regardless of screen resolution and/or picture size.
To delete the background picture, set the file name to a blank string.
Sub AddBackground()
ActiveSheet.SetBackgroundPicture Filename:="C:\My Documents\Test
Background.jpg"
End Sub
Sub DeleteBackground()
ActiveSheet.SetBackgroundPicture Filename:=""
End Sub
How important is it that the picture fit the user's full screen? Can the
picture simply be bigger than the screen, so that it appears to "truncate"
on monitors that are set to smaller resolutions? In other words, can you use
a single picture file (GIF or JPG) that will fit the largest screen
resolution used by all users?
Bill - thanks - We may have to do as you suggest, but the trouble is
that each picture contains an image so can't really be truncated
without losing some.. I have just posted a query on another approach
to the problem, which is to *insert* the picture on the draw layer,
then resize it to fill the screen, and then dump it once the initial
splash is over.. But how to resize it?? ..
Tks Charles
|