Programatically Unlocking a Project in the VBIDE

G

Guest

Here is the situation. We have a bunch of spreadsheets all with the same
module in them. I need to add Option Private Module at the top of these
modules as they expose some procedures that should not be exposed to the
users. I have the code to insert the line but the spreadsheets that contain
this module are locked. I have the password, but when I look at the VBIDE
object I can not find a method for unlocking the project. Chip's site does
not mention how to unlock the project and I can not find a solution on the
net...
 
G

Guest

Thanks Chip... That is what I was afraid of... My own mistake for leaving the
procedures exposed to the users... Now I get to fix them all manually...
--
HTH...

Jim Thomlinson


Chip Pearson said:
There is no programmatic way to unlock a protected project. The
only way is to attempt to use SendKeys. Not a very satisfactory
solution.


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com


"Jim Thomlinson" <[email protected]>
wrote in message
Click to expand...
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

unlocking VBA project programatically 1
Unlocking a Project 3
Trouble! Unlocking VBA project. 1
Project or Library missing 2
Locking VBA code via Project properties but cannot save the workbook over itself 4
How to retrieve subs and functions names of a project using VBA ? 3
Excel VBA Project Has Protection? 2
Excel 2003 - VBA to get a list of Module names in the project 4

Top