VBA code syntax to protect/unprotect VBProject asumming if Password is known.

[EagleOne]

2003, 2007

Is there a VBA (best VB.NET Visual Basic) way to protect/unprotect an Excel VBA VBProject?

I can do this in VBA for a WB and a Sht but I cannot find information on how to do the same for a
VBProject.

Frankly, many may feel that I am just trying to crack a locked project. Not true. I am just
attempting to set and remove a VBProject password using VBA directly, not via the typical form
approach.

Late last night I thought I saw something that inferred that passwording for XL VBProjects is
handled by only via Access?

If this is not possible, would someone just say that, as I have more time investment that reasonable
in just finding yea/nay re: possibilities.

If it is possible, consider placing a code example or at least the objects and modifiers used.

Any thoughts appreciated A link would be great. BTW, please no s/w cracking approaches.

EagleOne

 

[EagleOne]

Well, I guess the answer is no unless it be the "Ole" reliable SendKey.

Excellent reading on point:
http://www.cpearson.com/excel/vbe.aspx

EagleOne

 

[JLGWhiz]

Not that I know of. You have to do it manually.

 

[Peter T]

Just for the record all the dialogs, msgbox's and their controls associated
with changing Project properties can be manipulated (ie read/write) with
various APIs without the SendKeys requirement to be "on top", ie unlock
and/or change / add the password. (FWIW SendKeys won't work anyway with VBA
in Vista).

There's quite a bit of work (too much to post here), and if not familiar
with the approaches a learning curve. So before even thinking about going
down that route one has to ask why!

Regards,
Peter T

 

[Patrick Molloy]

under VBA Project Properties

AFAIK you cannot do this in code