Programatically Unlocking a Project in the VBIDE

J

Jim Thomlinson

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...
 
J

Jim Thomlinson

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

Check for Complie Error in VBA code via VBIDE 1
unlocking VBA project programatically 1
Programatically Enable VBIDE Reference? 10
Import module 9
Unlocking a Project 3
Excel 2003 - VBA to get a list of Module names in the project 4
Modify the gantt chart view in project center (WPA) (MS Project 2010) 0
Trouble! Unlocking VBA project. 1

Top