changing VBProject properties....

[buba]

thanks JustinEzequiel, for your valuable suggestions. they worked.. a final query though - We can lock a project for viewing and assign password to our project, using the 'Project Properties' dialog box. Can the same be done using any VBA coding?
Regards,
Buba

 

[aMember]

I have had success doing something like this (only able to do this from memory, sorry) :

VBProject.Unprotect sPassword
wbRef.VBProject.VBComponents.Remove
wbRef.VBProject.VBComponents("Module1&quot
VBProject.Protect sPassword

Be warned however. If the activesheet or visible form contains a command button that has

TakeFocusOnClick = true,

the code fails. Set it to false and it works fine.