View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Martin Bauer Martin Bauer is offline
external usenet poster
 
Posts: 6
Default errorcode if somebody is trying to change ...

good morning,


I'm currenly using a taylormade dll to send data, whenever a new value in
the sheet was calculated.

Now I have the problem, that If somebody is pressing the F2 key and try to
amend a value in a cell and not pressing ENTER - I guess excel is stopping
the recalc function - and I will send out "old" values

Is there an other way, than just use the protect mode in the sheet

I was imaging, that I will get an errorcode and than I'm able to work with
this error code


Any ideas

Ciao
Martin