Excel 365 crashes when trying to open Visual Basic Editor tools/options/Editor Format

Question

Hello,

My problem is:

I am using Office 365. Excel crashes when trying to open Visual Basic Editor Tools/Options/Editor Format to change the font.

How can I solve it?

Thank you.

Answer 1

Glad that it work.

Answer 2

Thank you Vijay for your prompt reply.

Repairings didn't work. I reinstalled office. It solved the problem. 

All the best.

Answer 3

Please try these options one by one and check after each option.

1. Sometimes, add-ins can cause problems. To determine, if add-in is a problem start your application in safe mode and see if problem has gone away.

To start in Safe Mode -

Hold CTRL key and click on application icon and don't release the CTRL key till it asks you for Safe mode confirmation.

If yes, then start application normally and disable add-ins one by one and start application again every time you disable an add-in to determine the culprit add-in.

To disable add-in > File > Options > Add-ins > Down below you have Manage: Com Add-in : Press Go > Untick the Add-ins to disable and tick to enable them

2. Try repairing your office installation (Quick repair is good enough). Try repairing your Office installation. First try Quick Repair (takes 5 - 10 mins) , if that doesn't help then try Online Repair (Takes more than 30 mins but less than 1 hour in general)

https://support.office.com/en-us/article/Repair...