“Project is Unviewable”: Solving errors when trying to open protected VBA projects

The message “Project is Unviewable” appears in the Visual Basic for Applications (VBA) editor when Excel blocks access to a macro project’s code tree.…

Fixing “Automation error: The object invoked has disconnected from its clients.”

The Excel VBA error “Automation error: The object invoked has disconnected from its clients” (error code -2147417848 or 0x80010108) occurs when VBA attempts to…

“Macros have been disabled”: Troubleshooting the “Trusted Locations” security block.

The “Macros have been disabled” alert appears when Microsoft Excel prevents Visual Basic for Applications (VBA) code from running because the workbook is stored…

Runtime Error 70: Permission denied (File access locks)

VBA Runtime Error 70 occurs when a macro attempts to write to, rename, move, or delete a file or directory that the operating system…

Runtime Error 53: File not found (Dir function failures)

VBA Runtime Error 53 occurs when a macro attempts to access, open, move, or delete a file using a file path that the operating…