Revisions Custom Excel Reports

We use macros extensively in reports from d-tools. Sometimes these reports fails when running macros during workbook open. and we end up with a useless report. Is it possible to implement a revisjon management here? Just automatically create a copy of the excel report before we change design?