I've done a little research and LibreOffice doesn't implement VBA in quite the same way as Excel, which I'm guessing is the problem. In theory I could grab a copy of LibreOffice and work something out, but in practice I have eleventy-billion things to do until mid-January so it's unlikely I'll get to that soon, if ever.