Project Locked ???

[mweaver]

greetings from Kansas

I recieved a really interesting workbook the other day and was curious about some interesting functions the author added to it.

When I went to access the VBA, I expected it to be passworded, but instead I got a message box saying: Project Locked! Project is unviewable.

I was not aware of a way to lock a project from view without passwording.

Can anyone explain this for me.

thanks mweaver
This message was edited by mweaver on 2002-09-05 10:08

 

[Ekim]

You will get this message if you are using Excel 97 and the project was protected in Excel 2000. You can also get the message if the workbook is marked as shared and/or your version of Excel includes Excel 5 or Excel 7 add-ins.

I assume that if you transfer the workbook to an Excel 2000 machine, you will get the password routine (I'm using Excel 97 and I have not tested this).

Comments from Microsoft on the topic:

OFF97: Error Message: "Project Is Unviewable" Trying to View VBA Project Locked or Digitally Signed in Office 2000 Program

http://support.microsoft.com/default.aspx?scid=KB;EN-US;Q229499&

XL97: "Project Is Unviewable" Error Message When You Try to View Project

http://support.microsoft.com/default.aspx?scid=KB;EN-US;Q169374&

XL2000: "Project Is Unviewable" Error Message When You Try to View Project

http://support.microsoft.com/default.aspx?scid=KB;EN-US;Q211792&

XL97: Cannot Modify Microsoft Excel 5.0 or 7.0 Add-in

http://support.microsoft.com/default.aspx?scid=KB;EN-US;Q160131&


Regards,


Mike

 

[mweaver]

!!!

Thanks EKim

mweaver