View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
CAP CAP is offline
external usenet poster
 
Posts: 1
Default email on condition from "import external data"


I am trying to get an excel worksheet to email me when a cell value
changes. I have been able to accomplish this if I manually change the
cell data or if it changes by formula.

My problem is, when the cell data changes by receiving new data from a
refresh of "import external data", the data change will not invoke my
send mail macro.

Any ideas?


--
CAP
------------------------------------------------------------------------
CAP's Profile: http://www.excelforum.com/member.php...o&userid=27720
View this thread: http://www.excelforum.com/showthread...hreadid=472351