Programmatically unprotect my protected project to delete modules?

T

Toby Erkson

I have set the "Lock project for viewing" in my Project Properties. Just to
keep away casual prying eyes. There is a section in on of my modules where
I delete other modules (but not the one where the code is running):

With ActiveWorkbook.VBProject
'Remove modules from wkbk
.VBComponents.Remove .VBComponents("UpdateKPIdatasets")
.VBComponents.Remove .VBComponents("zSupport")
.VBComponents.Remove .VBComponents("RegExps")
.VBComponents.Remove .VBComponents("UserForm1") 'Remove form from wkbk
End With

I get an error with the first .Remove and everything stops because the
project is protected. Okay, that's to be expected, so is there a way I can
programmatically Unprotect the project? The code does work if I unprotect
my project.
 
D

Dave Peterson

Maybe it's time to separate your workbook into two pieces--one for the data (a
template workbook maybe???) and one for the code.

Then any code that you need in the workbook can be stored in that template
workbook. And any code that you need (but not share) can be kept in the addin.
 

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

Top