20210204 1340
Can't find project or library 현상 발생
VBE > Tools > reference도 접근 불가
Googling results
"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...
'[PA] 업무자동화 > [XL]Excel & VBA' 카테고리의 다른 글
| XL reading PDF (0) | 2021.02.07 |
|---|---|
| XL Pivot AttributeRelationship doesnt exist (0) | 2021.02.05 |
| XL hidden information, 숨은 정보 찾아내기 (0) | 2021.02.01 |
| XL pivot, parallel labels(나란히 보기), measure(측정값), concatenateX, % bp (0) | 2021.02.01 |
| XL 연결된 셀로 이동, 수식 분석 Trace (0) | 2021.01.14 |
