Modify Password change all files in folders and subfolders, read only recommended

Originally Posted by dangelor

It would go into a standard code module of the workbook of your choice, saved as an .xlsm or .xlsb file format.

As to it doing something, it should change the password in your files from the 'old' to the 'new' password.

Before you run the code, be sure to change the 3 bolded variables in the code to match your situation.

When the code finishes running, check to see if you can open your files using the new password.

Worked like an absolute dream!

Cheers dude!