View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.programming
JLGWhiz[_2_] JLGWhiz[_2_] is offline
external usenet poster
 
Posts: 1,565
Default VBA code syntax to protect/unprotect VBProject asumming if Password is known.

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


wrote in message
...
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 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