Look at "application.caller" then use that value to find the button
(use buttons from the forms collection, not the control toolbox)

Sub FindMe()

Dim sName
Dim s

sName = Application.Caller
Set s = ActiveSheet.DrawingObjects(sName)
MsgBox s.TopLeftCell.Address(False, False)

End Sub

Tim


"cdde" wrote in message
...

can you make a macro assigned to button aware of where that button
is?

i want to use the same macro for all 250+ buttons i will have
associated to the row its placed on.....so i need the macro to be
aware
of what button triggered the macro and not to repeat the macro for
all
buttons.

on top of that....i need the macro to beable to know where the
button
is.....on what column and what row....if you need my code of
spreadsheet i can post it....thanx.


--
cdde
------------------------------------------------------------------------
cdde's Profile:
http://www.excelforum.com/member.php...o&userid=15532
View this thread:
http://www.excelforum.com/showthread...hreadid=271393