VBA help. VBA Prop.

[pedie]

Hi, is there a way for VBA to unprotect vba project properties and make changes to the module?
I have seen code that can make/replace the module but i help help to first unprotect it as well..
my temp. vba project prop. pass is "temp123"


Thanks in advance for helping.

 

[VoG]

Hi Pedie. As far as I know this is not possible - it would defeat the objective of password protecting projects.

 

[pedie]

Peter, thanks for the input....i was checking the project browser...it does not have unprotect method...

I was checking around and sendkeys only is the one way...

one more question...
how do i reference To VBA Extensibility?
What is this...i cant find this in the reference....


Thanks again.

 

[wigi]

See:

http://www.cpearson.com/Excel/vbe.aspx

 

[pedie]

Thanks alot that helps.....