"Vic Eldridge" wrote


focus/cell-reference seems to get lost.

I'm not sure what you mean by the above statement. What exactly is going
wrong ?


It looked like the "Target" was changed exidentially by the function-exec..
I found the cause now:

Set Pos = Application.Caller
Adresse = Application.Caller.Address

That are remains from tests and not necessary in the function.
After I commented it out everything runs ok!

At this point, there's two things I'd try.

Firstly, have a play with Application.Volatile and see if that makes any
difference.

Good hint, stmt. seems to be helpful in every function that is called from
cells.
But in this case it wouldn't have made any difference.


Secondly, you could use a public variable to prevent your function's code
from running

This would have been a solution. Thanks
a lot for assistance.

Best Regards
Peter
PS. By the way another question:
Is it possible to unprotect cells but keep the
"format" (like lines surrounding the cells, etc.)