So I haven't done that yet and I don't know if that helps in your case but I know that Excel::Writer::XLSX supports macros. At least it looks like it does. Have a look at WORKING-WITH-VBA-MACROS of Excel::Writer::XLSX.