Dear Ashidacchi,
Sorry that I answer only now, but your question started a long time of investigating my code. Immediately after your reply, I tried my excel program again and what a surprise: it worked. But then after a restart, the two functions didn't
not work again. I set up a simple test version, just using the two events: nothing happened first, but later on they worked fine.
My summary so far: Sometimes the two events work, when I start another fuction, sometimes not. Just by chance I discovered, that clicking the termination button of excel and choose the abort option, the two events start working. Once the
work, they keep working. Wehn I did the same with my test example, the messages I built into popped up much delayed as the had been waiting for some trigger.
So really, I have no clue what's going on. There must be something in my environment - excel office 365 vba for Mac - that prevents the two events to function properly. After struggling so long, I think I need to give up.
Thanks for your support anyway
Paul