Pictures tied to rows.

[David Henderson]

Are pictures tied to rows? If I set the properties of a picture to "Move and
size with cells" and it is within the cell "depth" then it is removed from
the sheet if the "parent" row is deleted, yes? Well anyway that is my
experience in Excel 2000, but not in Excel 2003, is this all correct so far?
Simple question, is there a way of identifying a picture "Embeded" in a Row
so that it can be deleted with code? 2000 & 2003.
Thanks in advance
David

 

[Guest]

Pictures have always been in a layer above cells. I don't recall a picture
being deleted because the row below it is delete.

If you want to delete a picture, then delete the picture. Turn on the macro
recorder. Select the picture. Hit the delete key. Turn off the macro
recorder.

That should give you some insights.

 

[David Henderson]

Tom,
I did that. In my limited experience the picture does seem to be deleted as
I described in 2000, and I know it does not in 2003. It can be associated
with a cell in Formatting/Properties Size & Position.I think my best bet is
to name each picture , just so that I know how to reference in macro code.
Thanks for your help
David

 

[Dave Peterson]

If you're deleting the rows in code, try:

With worksheets("whatever")
msgbox .pictures.count
'delete your rows
msgbox .pictures.count
end with

I bet that it's just gotten very small.