Project Locked ???

mweaver

Board Regular
Joined
Jul 28, 2002
Messages
129
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
 

Excel Facts

Square and cube roots
The =SQRT(25) is a square root. For a cube root, use =125^(1/3). For a fourth root, use =625^(1/4).

Ekim

Well-known Member
Joined
Jun 30, 2002
Messages
1,416
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
 

Forum statistics

Threads
1,144,152
Messages
5,722,807
Members
422,459
Latest member
Chriselff

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top