Cannot view code in VBE of a file with no password protection
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.
Subodh wrote:
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.
--
Dave Peterson
|