Using picture files
 

I have some shapes on a worksheet whose background 'colour' is a picture file.

At present the files location is specified using an absolute file name using
the
".Fill.UserPicture" method.

Two questions:

A) How can i use relative addressing instead (i.e. always assume the picture
is
in the same directory as the excel sheet iself)?

B) Better still... How can i link to a picture file in a seperate (hidden)
worksheet
within the excel file AND NOT to an external picture?


Thanks for all pointers in advance,

Mark.