How do I enable macros in Access 2013?

Question

Step 1 – Launch MS Access. Click on “Options”: Step 2 – Click on “Trust Center”, then on “Trust Center Settings”, “Macro settings”, select “Enable all macros” and click OK: Step 3 – Exit MS Access.

Why is my macro not working?

If your macro-enabled workbook doesn't work for another user it may be because the macros are in your Personal Macro Workbook and therefore inaccessible to other users. It's important to make sure to save macros into the workbook itself if you need to share it with others.

How do I enable macros disabled by enterprise administrator?

Enable macros just for the current session1Click the File tab.2In the Security Warning area, click Enable Content.3Select Advanced Options.4In the Microsoft Office Security Options dialog box, click Enable content for this session for each macro.5Click OK.Macros in Office files - Microsoft Support

How do you fix the macro may not be available in this workbook or all macros may be disabled?

Per Microsoft's KB, try allowing programmatic access to the Visual Basic project:Click the Microsoft Office Button, and then click Excel Options.Click Trust Center.Click Trust Center Settings.Click Macro Settings.Click to select the Trust access to the VBA project object model check box.Cannot run the macro... the macro may not be available in this workbook

Expert · Answer