If the project is not locked, look at

http://www.cpearson.com/excel/vbe.htm

for how to use code to work with code (you should be able to read your
constant by reading the lines of code in the code module).

However, if you don't lock you code, then anyone can go into your code
module and read the constant.

Maybe you could create a custom document property that holds an
encoded/scrambled version of the password and provide the code to
unencode/unscramble it.

http://www.cpearson.com/excel/docprop.htm


http://support.microsoft.com/default...b;en-us;224351
Dsofile.exe Lets You Edit Office Document Properties from Visual Basic and
ASP

--
Regards,
Tom Ogilvy



Rob wrote in message
m...
Hello FellowNewsgroupReaders,

I think I know quite a lot of protecting my projects and spreadheets.
I create a workbook called "A.XLS".
VBA code stores a password to open another sheet.
In VBA I declare a constant, like
const constPass = "123"
I protect the VBA code with a password.

If I open "A.xls" and create another sheet "B.xls", is it possible to
create code to read the constant from the VBA in "A.xls"?

I suspect it is NOT possible. I just want to know IF it possible in any
way.
If so, I cannot store my password in a constant and I need to find another
solution. But the solution above will help me make things easier.

Am I right with this?

Regards,
Rob Zoomer