Macro File Cannot be Found on Excel

Hi,
I have some work with Excel spreadsheet working with macros, I’ve been using it for months and my major problem is when I started to use macros for my files, it showed nothing unless a window say:
“A macro “xxxxxx. Sales report” cannot be found”
I’m very sure I have this file saved on my computer. And I’m very sure because it works sometimes. I just want this thing to stop for my smooth working time. (See image below, I removed some parts for confidential reasons)

Please help.
