0

My issue is that I have to secure multiple files on a shared drive, and I would like to lock access to their vba code.

I know that if you open the project in vba and click tools-­> VBA project properties -> protection -> lock project for viewing, you can achieve just what I want.

The problem is that I have hundreds of files to protect and I was wondering if there is a way to write a macro on a separate file that would go through all those I need and protect the access to the code in the same way the protection property described above achieves.

Thanks!!

Antoine P
  • 27
  • 4
  • 1
    Side note: [this protection can easily be bypassed](https://stackoverflow.com/questions/1026483/is-there-a-way-to-crack-the-password-on-an-excel-vba-project). – BigBen Jan 16 '20 at 14:04
  • So I have heard, but it is better than nothing – Antoine P Jan 16 '20 at 14:10

0 Answers0