Cannot view code in VBE of a file with no password protection

S

Subodh

I cannot view the code of a project in the Visual Basic Editor.
It says "Project is unviewable." with title "Project Locked"
It should prompt for password if the file was password protected from
the Protection--Lock project for viewing.
However this is not the case.
Is this some sort of protecition or is it something else than a VBA
Excel File??
Is there some way I can view the code??
Thanks in advance.
 
J

Joel

Somebody else may be accessing the file. Make a copy of the workbook and try
to open the copy and read the VBA code.
 
S

Subodh

Somebody else may be accessing the file.  Make a copy of the workbook and try
to open the copy and read the VBA code.





- Show quoted text -
Thanks for your help.
But, I am sorry.
I tried that but it didn't worked either.
Don't know why.
 
D

Dave Peterson

If the workbook is shared, you'll get this message.
Inside excel (not the VBE)
Tools|Share Workbook
is where you'd check (and unshare it)

If you're using xl97 and the project was protected in a newer version (xl2k or
higher), then you'll see this message. Use xl2k (or higher) to open the file
and remove the password. Then save it without the password so that xl97 can
view the project.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top