Visual Basic Button in Excel greyed out (Office 365) - Runs only in excel safe mode! How to solve problem?

Question

Hello,

As a reference to previous thread (https://answers.microsoft.com/en-us/msoffice/forum/all/visual-basic-button-in-excel-greyed-out-office-365/c7017329-0518-4618-8c3d-6f799779338e), in which case no solutions were found, Visual basic in my case works in safe mode ONLY.

Running as an administrator or other methods did not work, so in order to continue working with Visual basic how can I accomplish it without safe mode?

Thank you in advance.

Answer 1

Hi Nikola Svetić,

Thanks for the updates. You may share the screenshot with us by Private Message.

Additionally, some users in the forum reported the issue could be fixed by uninstall Office completely and reinstall it again.

You may try uninstall Office with Office uninstall support tool and reinstall it, then check the result. You may download from the link: Uninstall Office automatically. for your reference to install Office: Download and install or reinstall Microsoft 365 or Office 2019 on a PC or Mac.

Hope these can help.

Regards,

Clark

Answer 2

Hi Nikola Svetić,

I go through the post, if the visual basic is available when you open Office under safe mode, the issue could be related to some macros or add-ins in Excel, as you can check in the article: Open Office apps in safe mode on a Windows PC

 

I would suggest you disable all COM add-ins, Excel add-ins and macros used in Excel and check the result.

To disable add-ins: Add or remove add-ins in Excel.

To disable macros: change the macro settings in trust center to :”disable all macros with notification”

For more info: Enable or disable macros in Office files.

If suggestion above doesn’t help, could you please share information below with us for further troubleshooting?

1. What is your Office version? could you please share a screenshot of File>Account page with us?
2. If you create a new workbook in desktop, can you access VBE here?

Regards,

Clark

Answer 3

Hi,

here is the snipped picture:

Answer 4

Within Excel>File>Options>Add-ins>Manage Com Add-ins>Go....... what is listed whether active or not?