but_Name = Application.Caller

--
Regards,
Tom Ogilvy

"jmoffat" wrote in message
...

If you have assigned a macro to a shape - say a button from the forms
bar - and you then activate the macro by clicking on the button, does
anyone know the code to obtain the name of the button you clicked on ?

I think it should be along the lines of:

but_name = Activesheet.shapes.selection.name

but of course that doesn't work.


------------------------------------------------
~~ Message posted from http://www.ExcelTip.com/
~~View and post usenet messages directly from http://www.ExcelForum.com/

~~Now Available: Financial Statements.xls, a step by step guide to
creating financial statements