Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
errorcode if somebody is trying to change ...
If the sheet will need to have changes made on it, there is no way to allow
the user to make changes and not go into edit mode unless you handle all the interface with the user through your code with Userforms and so forth. -- Regards, Tom Ogilvy "Martin Bauer" wrote: 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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel bar chart formatting of bars to change colors as data change | Excel Discussion (Misc queries) | |||
Use date modified to change format & create filter to track change | Excel Worksheet Functions | |||
making copied cells change with change in original cell | Excel Worksheet Functions | |||
change info in other cells when i change a number in a drop list? | Excel Discussion (Misc queries) | |||
Change Cell from Validated List Not Firing Worksheet Change Event | Excel Programming |