One person opens the file in write mode. Another person opens the same file
in Read Only mode. At that time the Read Only user get the message: Macro
cannot be found (after activating a macro).

How can I solve this ?

Thanks in advance,
Coen Burger