Which picture was clicked

[Bob Flanagan]

I have several hundred pictures on a worksheet. I want to assign the same
macro to each picture, but have the macro determine which picture was
clicked. Is this possible?

Bob

 

[Dave Peterson]

Dim myPict as picture
set mypict = activesheet.pictures(Application.caller)

msgbox mypict.name & vblf & mypict.topleftcell.address 'or anything you want

 

[Bob Flanagan]

Many thanks.

Bob

Dim myPict as picture
set mypict = activesheet.pictures(Application.caller)

msgbox mypict.name & vblf & mypict.topleftcell.address 'or anything you
want