he file is in shared or co-edited mode or the file is in .xlsx format. Save as .xlsm (macro-enabled workbook).