Our 3-person team shares access to a single .xlsb workbook via Drop Box. For some reason, the VBA library will suddenly disappear for only 2 out of the 3 of us! To recover the library, the 3rd person (always the same person) needs to open the workbook and save it. Then magically the library is found and all the modules are there as if nothing happened.
Sometimes other VBA-related errors will be encountered randomly and again that same person needs to go in and save the workbook, and then magically everything works!
Any insight would be immensely appreciated, as this is becoming a more frequent occurrence and having to always ask the same person to "fix" the problem is taking its toll.