thank you for the feedback.
working with macro's isn't possible with the autosave that needs to be on to work simultaneously.
and working in the desktop version is automatically set in on the Sharepoint link because you loose a lot of functions indeed.