how to reset a password in Microsoft Visual Basics?

There is no supported way to reset or bypass a forgotten password on a protected VBA project or password‑protected Office document.

If the VBA project or workbook/worksheet is locked with a password and that password is unknown, Office does not provide any legitimate mechanism to recover or remove it. The only compliant options are:

1. Obtain the password from the person who set it, or from any documented password records your organization maintains.
2. Recreate the workbook and/or VBA project from scratch in a new file, based on whatever business logic and data are still accessible.

For future projects, consider implementing internal policies to ensure critical passwords are documented and stored securely (for example, in an enterprise password manager) so access is not lost when an employee leaves.

References:

• Set the properties for a Visual Basic project in Office for Mac
• password question - Microsoft Q&A I made a document with a password to it and now I can't remember the password to it. So how do I fix this without typing the passage again?