This browser is no longer supported.
Upgrade to Microsoft Edge to take advantage of the latest features, security updates, and technical support.
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(262.40000000000003, 28.000000000000004%, 35%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EGD%3C/text%3E%3C/svg%3E)
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?
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(134.4, 97%, 23%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EH%3C/text%3E%3C/svg%3E)
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
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.
Hi anonymous user
I am checking this thread, do you have any updates?
If yes, welcome to post back.
I did use the Office 365 portal to install Office.
The issue does occur with other Office apps like Word
The VBA Editor does not show by using Alt+F11
I have also run Excel and Word as Administrator yet nothing changed.
Though I just ran Excel in Safe Mode and the Record Macro option is available.
Excel has also given me this warning
"Microsoft Excel cannot access the file 'C:\Program Files\Microsoft Office\root\Office16\Library\Analysis\ATPVBAEN.XLAM'
Hi anonymous user
> Though I just ran Excel in Safe Mode and the Record Macro option is available.
Do you install any 3rd-party tools?
If this issue does not occur with Excel in safe mode, I would suggest you go to File > Options > Add-ins > Manage, COM Add-ins > Go, clear the check boxes for any enabled COM add-ins, select OK.
If disabling the COM add-ins alleviates the issue, try enabling them one at a time to test for the problem add-in.
Please also go to File > Options > Add-ins >Manager, "Disabled Items" from the list > Go, if there is "Solver", please enable it.
Then go to File >Options > Add-ins > Manage "Excel add-ins" > Select "Solver" from the list.
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.
Thank you for your response,
I just tried doing that and didn't work.
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(217.60000000000002, 99%, 31%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ETG%3C/text%3E%3C/svg%3E)
Thanks so much for that, that was my issue. I didn't have a cell selected.
I was kind of freaking out thinking I had to do all of the steps in the other comments haha but thankfully it was a simple solution