The way to unprotect excel workbook in VBA can be found in Google, like this:
step 1. Open Excel and find DEVELOPER in the navigation bar.
Step 2. Look for "view code" under this section.
Step 3. You will then be taken to the coding interface and now double-click on the password-protected form...
In addition to using VBA, manually deleting the encrypted password may be helpful in removing the Excel password.
Open Excel > click on File > Information and Permissions Options > click the "Encrypt with password" option and clear the password box > "OK" to delete the password > "Save".