XL cant find project or library

20210204 1340 

 

Can't find project or library 현상 발생

VBE > Tools > reference도 접근 불가

 

Googling results

"docs.microsoft.com/en-us/office/vba/language/reference/user-interface-help/can-t-find-project-or-library"

"stackoverflow.com/questions/46457621/references-in-vba-editor-not-opening"

"stackoverflow.com/questions/54559743/excel-vba-cant-find-project-or-library" ▶ this helps

 

안전모드로 엑셀 실행

▶win+R type "Excel.exe /safe"

▶ Alt+F11 will open VBE

▶ copy all code to new file...