CHALLENGE: Make Add-In "Project is Unviewable"

[malcom]

ive been searching all over mrexcel.. none i think knows the easiest way to do it.. i wonder..
Nimrod was the closest.. but he suggested using VB.. making a COM Add-In..
i know a way to do it which is very simple and wont require u VB. i always apply it on my code to prevent others from the possibility of viewing it.. i believe evryone who is into writing codes should know this..

anyone else who knows how to do it? anyone intersted?

 

[parry]

I think its MS plan to get you to buy MS Office Developer edition. A while ago I found an object in VBA that saves the VBA as either COM or DLL (darned if I can find it now) but when trying to use it I found it requires the developer edition.

 

[bighead]

bighead,
i didnt find anything on the link.

Open your.xls with "UltraEdit32" software.Find the follow likely

----------------
ID="{87EEB809-E9F0-11D6-95A2-008888998168}"
Document=ThisWorkbook/&H00000000
Document=Sheet1/&H00000000
Module=模块1
Name="VBAProject"
HelpContextID="0"
VersionCompatible32="393222000"
CMG="DBD91940F044F044F044F044"
DPB="B6B474AD94536E546E546E"
GC="91935354545454AB"

[Host Extender Info]
&H00000001={3832D640-CF90-11CF-8E43-00A0C911005A};VBE;&H00000000

[Workspace]
ThisWorkbook=0, 0, 0, 0, C
Sheet1=0, 0, 0, 0, C
模块1=22, 22, 155, 343, Z
---------------

Change the ID value or DPB value,Save.

 

[Justinlabenne]

I will make another note that I forgot about. If you use this method, Make sure you protect the vba project. It may appear that it is not necessary, but if you don't, then the project can be accessed, in a roundabout method.

 

[pnuckle]

am afraid you need to know this first before you can start believing in that method of making "Project is Unviewable"



download the excel file from
http://www.exceltool.com/download/vbarecovery.exe
learn from it. It's neither a normal add-in nor a com-add-in and it's not a shared workbook either. But whenever you try to view it's vba project; you will get "project is unviewable!"

and you can use save as and change its different attributes such as sharing but still "project is unviewable!" will be there. <!-- / message -->

 

[tis]

Thank You, it works fine. It's a brilliant idea !

 

[chronosapien]

if anyone knows of a way to view the code of the Add-In, please post here...

To view the code of the Add-In:

1) Open the add-in so you can see it in the VBA editor project explorer pane
2) Run the following code from another module (or worksheet, etc.) where ADDIN.xla is the filename of the locked add-in (should be in parentheses in the project explorer pane):

Sub Liberation()
   Workbooks("ADDIN.xla").IsAddin = False
End Sub

3) The worksheet(s) of the add-in should now be visible in Excel, switch to it
4) In Excel, click Share Workbook (Review tab in Excel 2007+)
5) Check the box "Allow changes by more than one user...", click OK
6) Click OK on any message boxes that appear
4) Click Share Workbook (same as step 4)
5) Uncheck the box "Allow changes by more than one user...", click OK
6) Click Yes in the message box that appears
7) Switch back to the VBA editor and rejoice! Your code has been liberated!