Macros will not work with Excel

So I have been creating workouts via excel for 5+ years and just recently I have a message pop up that says, "Cannot Run the macro "(file name)" The macro may not be available in this workbook or all macros may be disabled". I have worked with 2 people from Microsoft support chat and they still couldn't fix it. Any help here?