View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Norman Jones Norman Jones is offline
external usenet poster
 
Posts: 5,302
Default 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.