If you have Macro money, it might be time to get some C++ money and investing LibreOffice directly. (replace money with time if you're on your tod). They have a virtual machine brick you can download to get started with development which is quite handy.
One of the things that Microsoft Office does well is split users who are programming solutions from other users who could make use of those solutions. Everyone gets a nice easy to use VBA ghetto and no one need worry about collaborating on fixing a problem forever for everyone.