The easiest way to remove a forgotten VBA project password is to use a dedicated SysTools VBA Password Remover Tool. Follow these steps:
1. Install the VBA Password Remover Tool
o Download and install a trusted VBA password removal tool on your computer.
2. Open the Tool
o Launch the software and select the option to remove VBA project password protection.
3. Add the Protected File
o Browse your computer and select the Excel, Word, or PowerPoint file containing the protected VBA project.
4. Start the Process
o Click the Remove Password or similar option to begin processing the file.
5. Wait for Completion
o Let the tool process the VBA project and remove the password protection.
6. Open the File
o Open the processed file and access the VBA project to check whether the protection has been removed.
7. Keep a Backup
o Always keep a copy of the original file before making any changes.
Note: Only remove VBA protection from files you own or are authorized to modify.

If you want to know more - https://www.systoolsgroup.com/vba-password-remover.html