Is there a way to circumnavigate a password that is protecting VBA projects?

Cade Jones 1 Reputation point
2020-04-08T18:57:22.653+00:00

While trying to access a workbook, I encountered a Run-Time Error 91 message. After diving into a couple Excel Help forums, the most likely cause of the problem is an incorrect coding of VBA.

Herein lies the problem...the VBA projects are password protected and the person who created the workbook has since left the firm. Nobody who has access to the workbook would have tried to edit the VBA coding between when it was last successfully opened and when we realized the error, so we cannott think of any reason why this error would have occurred.

This seems to be an isolated issue on this particular workbook that pulls data from an external add-in. Any help is much appreciated!

Not Monitored
Not Monitored
Tag not monitored by Microsoft.
23,785 questions
No comments
{count} votes

1 answer

Sort by: Most helpful
  1. Dave Patrick 329.3K Reputation points Microsoft MVP
    2020-04-08T19:03:04.743+00:00

    QnA currently supports the products listed in right-hand pane (more to be added) Better to reach out to subject matter experts in dedicated forums over here.

    https://answers.microsoft.com/en-us/msoffice/forum/msoffice_excel

    https://social.msdn.microsoft.com/Forums/Lync/en-US/home?forum=exceldev

    (please don't forget to mark helpful replies as answer)

    No comments