Errors occurring in Visual Basic when using Excel on Windows 11 with an MS Office Family subscription

Question

새 통합문서에서 비주얼베이직을 열었을 때, 해당 화면처럼 ???? 되어서 보이며 비주얼베이직 이외의 다른 기능은 멀쩡히 잘 작동됩니다.

비주얼베이직이 사용되어진 다른 파일을 열었을때는 파일에 문제가 있다면서 문서내용을 복구하라고 뜹니다.

읽을 수 없어서 제거했다는 요소는 다음과 같습니다.

복구내용이 로그된 파일의 하이퍼링크를 눌러보면 이런 내용이 보입니다.

This XML file does not appear to have any style information associated with it. The document tree is shown below. <recoveryLog xmlns="http://schemas.openxmlformats.org/spreadsheetml/2006/main"> <logFileName>error158760_01.xml</logFileName> <summary>'C:\컴활\컴활1급실기예제\4-특강(3단계)\01-26년1회 상설 유형(모의고사24) 엑셀\1급 26년 1회(모의고사24) 엑셀 실습파일.xlsm' 파일에 오류가 있습니다.</summary> <removedParts> <removedPart>제거된 요소: /xl/vbaProject.bin 요소 (VBA(Visual Basic for Applications))</removedPart> </removedParts> </recoveryLog>

아래의 공식 링크를 이용하여 사용하던 365 ms office를 완전히 제거한 뒤

https://support.microsoft.com/en-us/office/lifecycle/officeinstall/uninstall-microsoft-365-or-office-from-a-pc

다시 설치해도 결과는 똑같았습니다. (이미 2번이나 반복했습니다.)

정상적으로 비주얼베이직을 사용할 수 있는 방법이 없을까요?

이러한 문제가 생긴지는 1주일도 안되었습니다. 기존에는 다 잘 되었었어요.

---

The following is the content translated using a translator.

When you open Visual Basic in the new sheet, it appears as '????' like the screen. but all other functions work fine.

When I open other files that use Visual Basic, it says there is a problem with the file and asks me to recover the document contents.

The elements that were removed because they could not be read are as follows.

If you click the hyperlink in 'the recovery details of the logged file', you will see the following.

This XML file does not appear to have any style information associated with it. The document tree is shown below. <recoveryLog xmlns="http://schemas.openxmlformats.org/spreadsheetml/2006/main"> <logFileName>error158760_01.xml</logFileName> <summary>'C:\컴활\컴활1급실기예제\4-특강(3단계)\01-26년1회 상설 유형(모의고사24) 엑셀\1급 26년 1회(모의고사24) 엑셀 실습파일.xlsm' 파일에 오류가 있습니다.</summary> <removedParts> <removedPart>제거된 요소: /xl/vbaProject.bin 요소 (VBA(Visual Basic for Applications))</removedPart> </removedParts> </recoveryLog>

Even after completely uninstalling and reinstalling 365 MS Office using the official link, the result was the same. (I've already repeated do this twice.)

Is there no way to use Visual Basic properly?

It has been less than a week since this problem occurred. Everything was fine before.

Answer 1

Hi, 인애 강

The “????” text in the VBA editor and removal of xl/vbaProject.bin strongly indicate a Windows language setting problem, not a damaged Office installation. VBA still relies on the system locale for non-Unicode programs. If that locale changed, or the UTF-8 beta option became enabled, Excel may misread Korean characters inside VBA projects and treat the macro data as corrupted. Reinstalling Office does not reset this Windows setting.

Here are some suggestions you can try:

Make a backup copy of every affected .xlsm file. Do not save the “repaired” version over the original, because Excel removes its VBA project.

Open Control Panel > Clock and Region > Region > Administrative > Change system locale.

Set Current system locale to Korean (Korea).

Clear Beta: Use Unicode UTF-8 for worldwide language support if selected, then restart Windows.

Open Excel, create a blank .xlsm file, add a simple macro, save, close, and reopen it.

Test an untouched copy of the original workbook.

If Excel already saved the repaired file after removing vbaProject.bin, the deleted VBA code must be restored from a backup, OneDrive Version History, or a previous copy.

Thank you for your patience in reading, I hope this information has been helpful to you. 

---

If the answer is helpful, please click "Yes" 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.