Hi,

I am trying to load a picture as background of an imagebox, using the following code:

sht1.OLEObjects("Image1").Picture = LoadPicture(filepath)

Unfortunately, I get an error using this statement. sht1 is a function, which represents Workbooks(1).Sheets(1)

Hoping you have a solution

-Max-

You can not use Sht1 as a variable object. The syntax should be:
x=1
y=1
workbooks(x).sheets(y).OLEObjects("Image1").Pictur e = LoadPicture(filepath)