View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Temoc Temoc is offline
external usenet poster
 
Posts: 1
Default how to send key "press" a key in a dialog?

While running a macro I have to send the active workbook by email, so the
send mail dialog box opens and awaits for a press button like response.

I want to press the button that says "yes"

How can I "press" the "yes" button by means of a macro instruction?