Have you considered exporting the macros and including them in a new spreadsheet? I haven't used it yet but Excel::Writer::XLSX has a tool, extract_vba, to extract a binary macro file and then you use the add_vba_project method to add your macro file to a spreadsheet.