Excel turned off when running Visual Basic

Question

Hello, I am a student using Excel.
If I click Visual Basic, Excel turns off. I used it well at first, but it suddenly doesn't work a few months ago.

I deleted Excel and re-installed it, but I can't solve it.

How can I solve this problem?

Thank you for reading it.

Answer 1

Hello, 채원 이7

I have realized your issue about the Visucal Basic.

Suddenly you had a day when this feature wasn't available?

If reinstalling doesn't help, it could be a problem with local cache files or add-ons, I suggest you try the following options.

1. Cancel add-ons

Click the document in the upper left corner of the file - Options - Add-ins - COM Add-ins Change location to manage, select "Move", uncheck all add-ins, click OK, restart the Excel document and see the effect.

2. Delete Excel templates

Make sure there are no files in the following folders:

1. Locate in C:\Users\User Name\AppData\Roaming\Microsoft\Excel\XLSTART and press enter to see if the file exists, if it exists, delete it, if not, close it;
2. Locate in C:\Program Files\Microsoft Office\root\Office16\XLSTART or C:\Program Files(x86)\Microsoft Office\root\Office16\XLSTART to see if the file exists, if it exists, delete it again, if not, close it;

3. Record Reset Office

Press Windows + R and type regedit in the Open Run box and press Enter.

Locate the following key and rename the Office folder (right-click and select Rename (for example, Office will be renamed to Officeold)):

HKEY_CURRENT_USER\Software\Microsoft\Office

Then open the Word document again to experience the effect.

Disclaimer: Registry or workgroup modifications are usually intended for power users, administrators, and IT professionals and can help resolve some issues, but incorrect registry modification can lead to serious problems. So, strictly follow the steps below. Make a backup of the registry before modifying it for added protection. For more information about how to back up and restore the registry, see: How to back up and restore the registry in Windows - Microsoft Support

I wish I could solve your problem, however, the problems seem to require more specialized support, I suggest you try to seek help on Microsoft Learn where there are more experts in related fields who can provide better solutions.

you can click "Ask a question", there are experts who can provide more professional solutions in that location.

Here is a link to the forum where you can raise specific scenarios and share your idea to help solve the problem.

Microsoft 365 - Microsoft Q&A

I sincerely hope that your question will be handled properly after contacting the correct department. Thank you for your understanding!

Feel free to post back if you need further assistance.

Thank you for your understanding and patience and I look forward to hearing from you.

Ryan - MSFT | Microsoft Community Support Specialist