View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
ryguy7272 ryguy7272 is offline
external usenet poster
 
Posts: 2,836
Default Call a cmdSend_Click macro; non-click interaction

I am trying to figure out a way to invoke this macro:

Private Sub cmdSend_Click()
€¦code
End Sub

As it is now, action is driven by a click event. I am using propriety
software which may require some kind of click event, but Im not sure about
that. How can I call this macro from another macro, without requiring a user
to interact by clicking the button.

This macro will be called by a worksheet event, which is triggered by a
change in a range of cells on another sheet.

Thanks!
Ryan--


--
Ryan---
If this information was helpful, please indicate this by clicking ''Yes''.