Developer tab (Macros completely hidden)

Question

Dear community,

I am not able to activate Macros. I have even contacted Microsoft and they redirected me here.

I have also activated everything in Microsft Trust Center settings.

Please refer to this Zip file containing the recording steps I followed.

https://1drv.ms/u/s!\*\*\*\*\*\*\*\*\*\*\*\*\*\*\* Thanks, Mario.

PII is mask by MSFT

Answer 1

Hi capmagn,

Thanks for your valuable feedback and sharing updates with us and I really appreciate your effort and your precious time doing. 

And I appreciate your kind words.

As you mentioned, "I tried opening in Safe Mode and it is appearing, however in normal Excel it is not."

If this situation disappeared in Safe Mode, then this issue could be caused by the incompatible add-ins, you can disable add-ins by this way: Open PowerPoint>add-ins>Disable add-ins. For reference: disable application add-ins and COM add-ins

Your understanding and patience will be highly appreciated. I hope that you are keeping safe and well!

Best Regards

Waqas Muhammad

Answer 2

Hello,

I tried opening in Safe Mode and it is appearing, however in normal Excel it is not. I also tried repairing Office and it didn't work. I have checked for updates, I have the latest version too.

Thanks again.

Answer 3

Dear capmagn,

Good day! Thank you for posting to Microsoft Community. We are happy to help you.

As per your description, please don’t worry, we can work together to narrow down and resolve the situation.

On my side, when I click on Developer tab the Macros buttons is active in Excel 365 app. See my test screenshot for your reference:

This can be occurred if you have a macro running.

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

Also, VBA editor (Alt and F11) and click on Run button and click on "Reset" (it is a square blue button on the tool bar) and click it.

If the problem happens to all Excel files including a new created one, the problem is more related to the Office app itself or your computer environment. You can first try suggestions below to see the result:

1. Make sure you’ve updated Office to the latest version that some issues can be resolved with such method.
2. Try open your Excel insafe mode which allow you to safely use it when it has encountered certain problems
3. If still can’t work, please try torepair an Office application to fix the problem.

In the meantime, I can’t reproduce the issue and to confirm whether this is a bug in a specific version, please provide us the version information. To check version: Open Excel>File>Account>Product Information and capture a full screenshot and share here and we will be tested on that version and verify the result with you.

Your understanding and patience will be highly appreciated. I hope that you are keeping safe and well!

Sincerely,

Waqas Muhammad

***Note: In the event that you're unable to reply to this thread, please ensure that your Email address is verified in the Community Website by clicking on Your Account Name > "My Profile" > "Edit Profile" > Add your Email Address > tick "Receive email notifications" checkbox > click on "Save".***