The error message “Error when compiling project or library not found” I had today, She was at one point, to the a variable not previously with Dim were been initialized. There stopped running when my Excel for MAC with the error message:
Fehler beim Kompilieren Projekt oder Bibliothek nicht gefunden
The cause was actually, that a Windows Library was not available, After the reference was removed, everything went back.
Visual Basic Editor-> Extras-> References
There, remove the tick with “DOES NOT EXIST”: