VB CODE PASSWORD for Project Locking

[Muratti]

You know that you can lock your project's code with a password through VBE for Excel. I am wondering if you can somehow create a code that gets triggered when a user enters a wrong password for this project locking password. This code should delete the code from the computer or automatically notifies the owner of the code that a wrong password is entered. I am trying to protect my code from piracy. Can somebody please help?

[Nimrod]

You could have users prompted for password in the Workbook_open event and if they give wrong password this code would delete all modules.

Private Sub DeleteAllModules(TargetBook)
'Deleting A Module From A Workbook

Dim VBComp As VBComponent

ThisModule = "ModManageMasters" ' prevent the deletion of this module
    
    For Each VBComp In Workbooks(TargetBook).VBProject.VBComponents
        If VBComp.Type <> vbext_ct_Document And VBComp.Name <> "ModManageMasters" And VBComp.Name <> "frmModManager" Then
             Workbooks(TargetBook).VBProject.VBComponents.Remove VBComp
        End If
    Next VBComp

End Sub

'Before using these procedures, you'll need to set a reference in VBA to the
'VBA Extensibility library. In the VBA editor, go to the Tools menu, choose
'the References item, and put a check next to "Microsoft Visual Basic For
'Applications Extensibility" library.
'If you are using Excel97, this library will appear in the References list
'without a version number: "Microsoft Visual Basic For Applications Extensibility".
'If you are using Excel2000, it will appear with a version number: "Microsoft Visual
'Basic For Applications Extensibility 5.3". It is very important that you reference
'the proper library. If you don't, you will receive "Type Mismatch" errors.
'''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''

http://www.cpearson.com/excel/vbe.htm


_________________
NOTE: Testing performed on Win2K utilizing Office 2000. Solutions may need tweaking for other versions.

Adieu,Nimrod

[ This Message was edited by: nimrod on 2002-05-22 10:53 ]

[Russell Hauf]

There really isn't a way to do this that I know of. As far as I know, the only way to truly protect an add-in is to create it in C++.

As for the workbook_open event suggestion, if the user selects disable macros (or holds down the shift key), the workbook_open event won't fire.

Sorry I couldn't be of more help,

Russell

[Muratti]

Nimrod Thanks. But I already have a password box for entering the software. My concern is if they go to VB editor and try to see the code. Yes, I made the project locked with a password but I do not know how reliable is it.
Do you have any idea about this?