[Webinar] Streamline your web hosting managementRegister Today

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 1150
  • Last Modified:

Enable Macro Excel 2013, not working

File/Option/Trust Center/Trust Center Settings.../
Macro Setting/Enable all macros (...)

Save/close/reopen

are steps I follow but when I click on a button with a macro, it says:

'Cannot run the macro 'FileDNA!Macro2'. The macro may not be available in this workbook or all macros may be disabled.

Question: What can I do to make this macro work.

FYI, the macro worked fine when I first created it. I save the workbook. Now I have reopened the file but it is no longer working.
0
Mike Eghtebas
Asked:
Mike Eghtebas
  • 3
  • 2
2 Solutions
 
Rory ArchibaldCommented:
Can you run the macro manually from the macros dialog?
0
 
Mike EghtebasDatabase and Application DeveloperAuthor Commented:
Hi Roy,

You are very quick. After I posted the question, to make sure the macro is still there, I checked it but it wasn't. I need to recreate it. I don't know what must have happened to it?

brb
0
 
Ejgil HedegaardCommented:
Probably the button points to a macro in a closed workbook.
Right click the button, attach macro, and see what is displayed.
And attach the button to the macro in the active workbook.
0
The new generation of project management tools

With monday.com’s project management tool, you can see what everyone on your team is working in a single glance. Its intuitive dashboards are customizable, so you can create systems that work for you.

 
Mike EghtebasDatabase and Application DeveloperAuthor Commented:
After I created the macro again, it worked. But, after I saved/closed/reopened the macro was not there.

Question: Why am I loosing the macro?
0
 
Mike EghtebasDatabase and Application DeveloperAuthor Commented:
I see, when I save the macro, it gives me yes/no/cancel options.

I have been clicking on yes option but I had to click on No option to keep the macro. But with No option it is asking me to: "choose a macro-enabled file type in the file type list."

What all these instruction mean?

Is it asking me to have a file like myMacros.??? with some specific extension where this file is also macro-enabled?
0
 
Ejgil HedegaardCommented:
You have to save the workbook with macros.
Use Save as, second option.
0

Featured Post

Keep up with what's happening at Experts Exchange!

Sign up to receive Decoded, a new monthly digest with product updates, feature release info, continuing education opportunities, and more.

  • 3
  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now