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

  • Thread starter Thread starter EagleOne
  • Start date Start date
E

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
 
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
 
Back
Top