dim myBTN as button
set myBTN = activesheet.buttons(application.caller)
msgbox application.caller & vblf & mybtn.topleftcell.address _
& mybtn.caption
(Not sure what the ID is.)
wardides wrote:
I need to also work out which button has been pressed.
set cell = Activesheet.Buttons(1).TopLeftCell
will work once I know what button has been preseed. Is there code that
will give me the ID of the button that has been pressed ?
--
wardides
------------------------------------------------------------------------
wardides's Profile: http://www.excelforum.com/member.php...o&userid=15022
View this thread: http://www.excelforum.com/showthread...hreadid=266858
--
Dave Peterson