Share via

VBA and Record Macro Greyed out on Excel

Gonzalez, David 5 Reputation points
2022-01-18T16:57:16.61+00:00

So I have been trying to Record a MAcro on Excel for a while but the option to record one and to access VBA is greyed out in Excel.
I have enabled all macro settings on Excel and even uninstalled and reinstalled Office 365.
What else do I do to resolve this issue?

Microsoft 365 and Office Development Other
Microsoft 365 and Office Excel For business Windows
0 comments

3 answers

Sort by: Most helpful
Most helpful Newest Oldest
  1. HughesD 6 Reputation points
    2022-07-21T14:37:11.857+00:00

    I was having a similar issue, but I realized my error was self-induced. I was trying to record while the "debugger" was running - and recording macro was greyed-out/disabled.

    In the VBA window (Alt+F11) hit the stop button (blue square) to stop the debugger and macro recorder is re-enabled

    1 person found this answer helpful.
    0 comments
  2. Emily Hua-MSFT 27,796 Reputation points
    2022-01-19T06:49:25.52+00:00

    Hi anonymous user

    Welcome to Q&A forum ~

    > even uninstalled and reinstalled Office 365.

    Did you install Office from Office 365 portal?
    Or did you run ODT with configuration file (.xml)? If so, please share us with this configuration file.

    Does this issue occur with other Office apps? Such as Word, PowerPoint.

    If you press Alt + F11, will the VBA Editor shown up?
    If you can see the VBA Editor, please check whether there is any macro running.

    I would suggest you right-click Excel, run as administrator to check this issue.

    Then it's recommended to run Excel in safe mode to check these button.
    Safe mode could help us troubleshoot installed COM add-ins.

    Besides, you could temporarily disable antivirus software.

    Any updates, please feel free to post back.

    If the answer is helpful, please click "Accept Answer" and kindly upvote it. If you have extra questions about this answer, please click "Comment".
    Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.

  3. OssieMac 416 Reputation points
    2022-01-19T11:19:28.47+00:00

    I wonder if you are clicking in the formula bar or some other icon in a ribbon before attempting to record.

    You must select a cell on the worksheet before clicking on record.

Your answer

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