Picture as part of a named range

**Stumped123** · 03-04-2013, 01:20 PM

I am looking to make pictures a named range to be used in a drop down box. I insert the pictures on sheet 2 and name the cell range they are in, but the drop down box on sheet 1 is blank??????

**HaHoBe** · 03-04-2013, 01:32 PM

Hi, Stumped123,

pictures can´t be inserted into cells but they will always be in a layer over them. AFAIK no chance to do what you want to do.

Ciao,
Holger

**Stumped123** · 03-04-2013, 01:36 PM

can you suggest another option? I have signatures in individual PDFs. I need to design a way to insert a signature onto a form created in excel.

**HaHoBe** · 03-04-2013, 01:46 PM

Hi, Stumped123,

for me I´d go with VBA to solve the problem. The alternatives for that would be to have all pictures and get the wanted on top or delete the shape and add a new one on pasting the image. I think I have seen it being down with formulas but right now I can´t remember how the issue was being solved.

Ciao,
Holger