I have a table with a picture in each row. (And by "in", I mean its top is aligned with the row top, and its left edge with that of Column K. The row is sized to accomodate the height of the picture.)

For each picture, a macro had inserted a text string in its Name property (the string is the filename of the picture I imported). I'd like to display the Name in another column of that row. Because the pictures don't always sort correctly when the table is sorted, I'd need the column of Names to "refresh" automatically.

I know I could do this using a VBA macro, but the user would have to remember to press that button every time he sorts the table. I would like either: a) A formula that can extract the Name property of a picture, or b) a macro that will run itself whenever the table is sorted.