View Single Post
  #8   Report Post  
Posted to microsoft.public.excel.programming
Norman Jones Norman Jones is offline
external usenet poster
 
Posts: 5,302
Default Get Name of Macro Initiator

Hi Space Camel,

Try sometging like:

'=============
Public Sub Tester()
MsgBox Application.Caller
'Your code
End Sub
'<<=============

---
Regards,
Norman


"SpaceCamel" wrote in message
...
I have many graphical buttons on a sheet with different names/properties
but
all initiate the same macro. I need the macro to get the name/properties
of
the initiating button.

Is there a "who started me" value I can get?

Thanks,