Share via

How to Enable VBA Macros

Apple E Mananquil 10 Reputation points
2023-05-23T13:09:15.7466667+00:00

Hi,

Good day!

I'm trying to use my VBA Macros applications, but I'm having this error message. Please help me resolve this.

It's really a pleasure you would help me with this ASAP.

Thank you so much!

Microsoft 365 and Office | Install, redeem, activate | For business | Windows
Microsoft 365 and Office | Excel | For business | Windows

4 answers

Sort by: Most helpful
Most helpful Newest Oldest
  1. Olaf Helper 47,621 Reputation points
    2023-05-24T06:28:07.15+00:00

    but I'm having this error message.

    Which error message do you get?

    Have you installed VBA as optional feature at all; by default the feature is disabled?

    Was this answer helpful?

    1 person found this answer helpful.
  2. Tanay Prasad 2,260 Reputation points
    2023-05-24T05:46:37.0766667+00:00

    Hi,

    Please share the error message you're facing.

    Apart from that, here's how you can enable VBA macros:

    1. Open Excel and click on the "File" tab.
    2. Select "Options" from the left-hand side menu.
    3. In the Excel Options dialog box, choose "Trust Center" from the left-hand side menu.
    4. Click on the "Trust Center Settings" button on the right-hand side.
    5. In the Trust Center dialog box, select "Macro Settings" from the left-hand side menu.
    6. Check the "Enable all macros" option.
    7. Click the "OK" button to save the changes and close the Trust Center dialog box.

    Best Regards.

    Was this answer helpful?

    1 person found this answer helpful.
    0 comments
  3. Deleted

    This answer has been deleted due to a violation of our Code of Conduct. The answer was manually reported or identified through automated detection before action was taken. Please refer to our Code of Conduct for more information.

    Comments have been turned off. Learn more

  4. Deleted

    This answer has been deleted due to a violation of our Code of Conduct. The answer was manually reported or identified through automated detection before action was taken. Please refer to our Code of Conduct for more information.

    Comments have been turned off. Learn more

Your answer

Answers can be marked as 'Accepted' by the question author and 'Recommended' by moderators, which helps users know the answer solved the author's problem.