Password protecting many workbooks

[Ironman]

Hello - - I've used this bit of code before that worked just fine in setting an active workbook with a pasword:

Please Login or Register  to view this content.

My question would be is there a way I can modify this code to set a password on the workbook that is NOT open? I have a monthly routine where by I'll have to open 16 workbooks and issue a 'save as' with a password. I was hoping someone might have a thought/suggestion on how I could do this without opening each of the 16 workbooks (at least manually). If someone might have one example I could duplicate that 16 times. Thanks again and may you all have a happy New Year!

[Leith Ross]

Hello Ironman,

For security reasons, Excel does not allow you to open, change or access a password in closed workbook. The workbook must first be opened before the password can changed or removed.

If you have a main workbook that opens the files via code then you can automate the process of "Saving As" with a password for each workbook. You would need to provided more information and/or code before I can give you a specific example.

[Ironman]

Thanks Leith for the reply - - I did find a solution. I have what I call a 'master report' excel file that I use to store and run various vba code from the personal.xls file...below is what I've done for two test files, works great...so I would just duplicate the one section 16 times and change the file name to open and then add a password to, then close the file...then move onto the next file (open/save as with password/close)...Here is a copy of my code:

Please Login or Register  to view this content.

Happy New Year!

[royUK]

If you workbooks are named Test1, Test2 etc then this might be better

Please Login or Register  to view this content.