Applying background with VBA from worksheet

[Cease]

Hi,
I'm trying to set a background using vba for a file that may be emailed to other machines; and where the background would periodically change based on user selections.

I have been able to change the background from my machine, using:

 ActiveSheet.SetBackgroundPicture Filename:= _
        "\\DTCDAT-VARO050\C_PBO_Users\A763789\My Documents\Images\Star Wars Spacefight.jpg"

I have the image stored as an object within another worksheet that I would like to pull from.
"Sheet17"
it was named Picture 7 but I Changed it to ForcePic


Is there any way to take "Forcepic" from page 17 and set that as the background on another sheet using vba? For this example we can just say Sheet1

I've tried a lot of different options and keep coming up with object undefined errors resulting from my own ignorance with vba.

Any help or direction would be greatly appreciated.

Thank you!

 

[Cease]

Hey,
Maybe it will help showing where I'm stuck.

Sub newback()
    Dim Pic As Picture
    Windows("Beast PreMacro.xlsm").Activate
    Sheets("Sheet17").Select
    Set Pic = ForcePic
    Windows("Selection of Beast PreMacro xlsm May-16-2011 (2).xlsx").Activate
    Sheets("Sheet1").Select
     ActiveSheet.SetBackgroundPicture Filename:= _
        Pic
End Sub

This stops on the 4th line at 'Set Pic'...
SayingRun-time error '424' Object Required

Any suggestions?

Thank you!

 

[Cease]

Hey,
I feel like I'm closer:

Sub newback()
    Dim Pic As Excel.Picture
    Windows("Beast PreMacro.xlsm").Activate
    Set Pic = Worksheets("Picky").Pictures("ForcePic")
    Windows("Selection of Beast PreMacro xlsm May-16-2011 (2).xlsx").Activate
    Sheets("Sheet1").Select
     ActiveSheet.SetBackgroundPicture Filename:= _
        Pic
End Sub

This comes back with Run-time error 13: Type Mismatch, highlighting the last line.

Any idea if there's a way to change the syntax of the SetBackgroundPicture to get this to work?

I know you guys are pretty amazing at this, any ideas, thoughts or advice, please let me know.

Thank you!

 

[Cease]

Hi everyone,
I'd try this as a new post; but don't want to be that guy.

Can anyone tell me a good place that references how to use pictures in VBA?
Furthermore anyone have any idea if there's a method of the SetBackgroundPicture argument to set the background from a picture that is within a worksheet?

It is a minor thing in the scheme of the workbook I'm building, but it would be a tremendous help to the appearance of it.

Any questions about the sheet or what I'm trying to do, please let me know, I'll be happy to elaborate.

More than that, I'd be greatly thankful for any help advice or direction.

Thanks again!