Is there a way to unlock a project in VBA if you know the password
 

I have a project I need to be able to write to the VBE of.

The project is mine, however I've locked it so that other's cannot go in and
mess what I have up (also gives me a little more control of what can and
can't be seen).

I need to be able to write to the VBE of one of these locked workbooks
during the course of other procedures. I know in pervious versions of Excel,
the VB Project wasn't visible to VBA but was wondering if this had been
altered in 2003?

If not, can you suggest any other ways short of not locking it in the 1st
place?

TIA.

Is there a way to unlock a project in VBA if you know the password
 

Hi DaveO,

See:

http://tinyurl.com/nljtd


---
Regards,
Norman


"DaveO" wrote in message
...
I have a project I need to be able to write to the VBE of.

The project is mine, however I've locked it so that other's cannot go in
and
mess what I have up (also gives me a little more control of what can and
can't be seen).

I need to be able to write to the VBE of one of these locked workbooks
during the course of other procedures. I know in pervious versions of
Excel,
the VB Project wasn't visible to VBA but was wondering if this had been
altered in 2003?

If not, can you suggest any other ways short of not locking it in the 1st
place?

TIA.