I need a way to have a worksheet auto-delete after a period of 3 years from when it was created. I currently have worksheets being exported from a working document every time I click an export macro button. This copies that worksheet with the date as the name of the tab. Not sure if this can be worked into the vba code or if its a setting within the workbook itself. Any help would be appreciated. Heres the code i have to export:
Code:
Sub Copysht()
Workbooks("FINAL_JUMP MANIFEST_FINAL.xlsm").Sheets("DZ LOG").Copy before:=Workbooks("DO NOT DELETE_MASTER DZ LOG.xlsm").Sheets(1)
Workbooks("DO NOT DELETE_MASTER DZ LOG.xlsm").Sheets(1).Name = Format(Date, "DD-MM-YYYY") + " Chalk 1"
End Sub