Creating Directories
 

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

Creating Directories
 

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