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

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

wrote:

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

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

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

wrote:

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

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

under VBA Project Properties

AFAIK you cannot do this in code

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