Password Protect / Unprotect Multiple Workbooks?

[manny77]

Hi there,

My first time posting so apologies if I don't have the format down pat yet.

I have about 50 workbooks, each with a unique password that I know.

Once a month I have to update a few fields in each, which means I have to open the file, enter the password, make the changes, save and close.

Is there a way I could automate the process of unprotecting the files at the start? For example, could I do something to remove the protection for the given files, and then at a later point add protection back to all files?

I use Excel 2007

Thanks in advance,
Manny

 

[jasonb75]

Hi there,

I'm not having any luck- am I wrong to think that the code won't run until the workbook is open, and to open the workbook you need the password?

Anyway- it still asks for password to open file.

Manny

Did you edit your correct detail into the code?

The code I provided as an example does work, but is written to use the password "your password" to unlock "sheet1" when "manny1" or "anna" is logged in as the windows user.

To actively use the code on your own workbook(s) you would need to edit those parts of the code so that they are correct to the workbook on which the code is being used.