엑셀 사용자 정의함수, 매크로, 프로시저 작동 안됨. DLL오류라고 뜸.

Question

사용자 정의함수, 매크로, 프로시저 사용 시 DLL오류라고 뜨며 되지 않습니다.

재설치해도 해결이 안됩니다.

Answer 1

Thanks for sharing the details, 정주! You can check Missing References, dll errors often points to missing references. Here's how to check:

ALT + F11 to open VBA

Go to Tools then References

Look for:

• MISSING: XXXXXXX

If you see a missing reference, uncheck it, recompile VBA (Debug then Compile), then close and reopen Excel.

Also double check your add-ins aren't broken.

Go to: File then Options then Add-ins At the bottom choose:

• Manage: COM Add-ins select Go
• Manage: Excel Add-ins select Go

Disable everything then restart Excel and try again. Then enable one by one.

See if this helps. If you need further assistance just let me know.

Best regards,

Kimberly