Which picture was clicked
Many thanks.
Bob
"Dave Peterson" wrote in message
...
Dim myPict as picture
set mypict = activesheet.pictures(Application.caller)
msgbox mypict.name & vblf & mypict.topleftcell.address 'or anything you
want
Bob Flanagan wrote:
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
|