Floating picture - stationary with scroll, moves out of way

[Rod684]

Hi All,

I'm a newbie here so please be gentle.

I am attempting to insert a picture (text box is acceptable) that remains within the active worksheet view whilst scrolling, but can also move away from active cells when tabbing through the sheet. The picture is a legend and I would like to have it always within view no matter where you are on the spreadsheet.

Thanks in advance.

 

[Jaafar Tribak]

Take a look here and here and see if you can adapt the codes to meet your requirements

 

[niderost]

Great Code.
I am trying to modify it to keep a chart in a specific location as the sheet scrolls but keep getting the error "Object doesn't support property or method". I have tried using it as a procedure and call the procedure from the sheet event and it almost works. I only get a thin black line that moves to the prescribed location upon a new selection. It only works when I use the Shapes object but not the ChartObject or Charts. Could the thin black line be the chart, but the size is screwy? If so, why does the original chart still remain? Any help, This seem like it will be a cool feature if i can get it to work.

Thanks

I changed ActiveSheet.Pictures(1) into ActiveSheet.ChartObjects(1) and it worked right away.

 

[icesanta]

Can we float 2 picture by "image file file name" in a sheet one in Upper middle and another in upper RHS ?