Project Unviewable

[sa.1985]

Dear Sir,

My excel file is protected with password, error show in vba (Alt+f11) is "Project Unviewable"

 

[Hui]

One reason is that the author of a workbook or add-in locked it from viewing to prevent you from seeing the code.
You protect a project via the VBAProject Properties dialog, Protection Tab.
If this is the case you will need the password.

If the file is on a network, try to unshare it
To unshare it to open the VB project.
You can always share it again if you want to.

 

[sa.1985]

Password not remember.
Then what can we do ?

 

[Villalobos]

@sa.1985

If the file is yours and you just forgotten the code then... for instance the Hex editor can help you to unlock the VBA project.

http://stackoverflow.com/questions/22663809/excel-vba-password-via-hex-editor or http://stackoverflow.com/questions/272503/how-do-i-remove-the-password-from-a-vba-project

 

[Petros]

The Hex editor may not help you to unlock a VBA project that is Unviewable. Hex editing is more complicated for unviewable projects compared to plain VBA password removal. You risk corrupting the workbook if you edit bytes without knowing its inner workings of the file.

Unviewable projects are made for 2 reasons:

1) When a workbook is Shared. To remove a shared password use:

http://www.spreadsheet1.com/password-protection-remover-free-office-excel-add-in.html

http://www.thespreadsheetguru.com/passwordrecovery


2) Unviewable projects are created to protect VBA code from hacking using this tool:

http://www.spreadsheet1.com/move-excel-vba-projects-from-one-workbook-to-another.html

 

[sa.1985]

Thanks.