Password Protection

Isn't this the point of passwords?
So that other users can't do exactly what you are asking?

Forum Rules

12. Do not post questions with regard to breaking or bypassing a password of any type or post questions with regard to bypassing a users security settings, all such posts will be deleted, repeat offenders will be banned!

I'm with Marcol here. If there were a way to run a macro that replaces any existing password with a new one, that would defy the purpose of password protection.

If you are the rightful user of the files and know the passwords, and if you want to change them, then you need to take the time to change the password on each file. One by one.
Anything else would be considered hacking and any advice on that is not supported in this forum.

Your post does not comply with Rule 12 of our Forum RULES. Do not post questions with regard to breaking or bypassing a password of any type or post questions with regard to bypassing a users security settings, all such posts will be deleted, repeat offenders will be banned!