I guess he might have saved the workbook as .xlsx. Save the workbook either .xlsm or .xlsb.