View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Mike H Mike H is offline
external usenet poster
 
Posts: 11,501
Default Calling a Macro from multiple places in Excel sheet

Hi,

Parent.Caller

will give the name of the picture that called the macro

Mike

"Robert Reid" wrote:

I am using Excel 2003. I have a worksheet with multiple pictures in it. When
any of the pictures are clicked, a macro is called. I cannot figure out how
to determine which picture was clicked to call the macro. Any help would be
appreciated.

I apologize if this is a question from VBA101. I'm kinda slow. :)