We have a workbook, "followup_care.xlsm", in which data is moved to sheet "Done" and we like to move sheet "Done" to a new workbook ,saved with the date in the new workbook name, and both workbooks save and close.
Private Sub Workbook_BeforeSave(ByVal SaveAsUI As Boolean, cancel As Boolean)...