Lock access to the VBA project via VBA

[Engineer Joe]

Either my google-foo skillz are waning or google itself just isn't useful in finding the distinction in my inquiry, so here I am. Long time, no see Mr. Excel. Let me preface my question with this. When you go into in the VBA project for an Excel file and click on the Tools Dropdown and select "VBAProject - Properties," you get a pop-up window and then select the "Protection" tab, you can lock the project with a password. I need to do this via VBA. So that's my question. How do I accomplish this via VBA. I need to do this via VBA because I've got a ton of worksheet-specific XLSM files. I got some code several years ago that I employ regularly that lets me open a bunch of files in a subfolder and execute whatever macro I want on those files. So, basically, I want to run this on my entire file folder structure for all XLSM files. So the code I need is firstly the code to lock all the files...then I need another bit of code to unlock the files automatically that I would conceivably insert into my personal addin that just unlocks the files when I open them. Can anyone help me figure that out? Yes, a little bit inception-esque here, so I figure it'll be kind of fun for whoever knows how to do it. Alrighty, I'm eagerly awaiting a reply from a true Excel master whom I'll worship endlessly and create a little shrine to if you can help me out here.

THANKS!

 

[Michael M]

This might pooint you in the right direction, but it uses SendKeys, which are very unreliable.

Protect VBA project using VBA

When my VB project finishes running, it saves a new copy of the excel workbook, and then e-mails this to a provided distribution. When the code is run, the VB project should be unprotected, allowin...

stackoverflow.com

 

[James006]

Hi,

If you need to modify your VBA project you should use the VBA Extensibility library.
see Chip's excellent explanation :

Programming In The VBA Editor

www.cpearson.com

 

[Skyybot]

In VBA window click Tools. Then click VBA Project Properties. Click the Protection Tab. Lock for viewing and enter Password.

 

[Skyybot]

In VBA window click Tools. Then click VBA Project Properties. Click the Protection Tab. Lock for viewing and enter Password.

I should've read the entire post. Disregard my answer.