Macro File Cannot be Found on Excel

Asked By 0 points N/A Posted on -
qa-featured

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.

SHARE
Answered By 0 points N/A #123554

Macro File Cannot be Found on Excel

qa-featured

Hi

Here is the error for you. If you have a macro on your worksheet then, it might have been disabled by the macro security centre. Ms Excel deletes some macros without any notification. You can visit this web page and get more information about that. And fix you problem.

Microsoft Office Excel

Or

  • Go to the developer tab and open macro security.
  • Or go to Office button and add the developer tab and open it by using Excel option given in the Office button.
  • And there go to the macro setting option and change the necessary changes you should change, after that try to run the macro again. 

Related Questions