Solved

VBA strong protection software

Posted on 2014-10-02
3
192 Views
Last Modified: 2014-10-03
I have developed an add-in recently, i want to share it as a free license to everyone, but i want to strongly protect the VBA codes inside its modules.   i know that the password protection is the weakest,  also sharing the workbook and making it then add-in also is breakable, the shared workbook "project is Unviewable" works but i have found that users still break this.

i was wondering if there is any commercial software or any encryption software that can buy license that can protect my excel add-in.
0
Comment
Question by:ProfessorJimJam
3 Comments
 
LVL 27

Expert Comment

by:MacroShadow
ID: 40358119
You can try LockXLS I cannot vouch for the software as I have never tried it, but it was highly recommended on this site before.
0
 
LVL 27

Accepted Solution

by:
Glenn Ray earned 500 total points
ID: 40358220
If you have VB6, you should be able to copy your code into that and save it as a COM add-in.  That would be a lot more secure, IMO.

Reference:
http://www.cpearson.com/excel/creatingcomaddin.aspx

-Glenn
0
 
LVL 11

Expert Comment

by:jkpieterse
ID: 40358868
But a VB6 COM add-in would not work on 64 bit Office...
0

Featured Post

Courses: Start Training Online With Pros, Today

Brush up on the basics or master the advanced techniques required to earn essential industry certifications, with Courses. Enroll in a course and start learning today. Training topics range from Android App Dev to the Xen Virtualization Platform.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Title # Comments Views Activity
Compare 3,000cells with each one of 500,000 cells, how? 83 47
.Range Set 25 75
Move data from one sheet to another 11 30
Msgbox tickler 10 22
This tutorial explains how to create a series of drop-down lists that are dependent upon prior selections to guide (“force”) the user to make the correct selection and reduce data errors within Microsoft Excel. Excel 2010 was used for this tutorial;…
This article descibes how to create a connection between Excel and SAP and how to move data from Excel to SAP or the other way around.
This Micro Tutorial demonstrate the bugs in Microsoft Excel for Mac with Pivot Charts.
Many functions in Excel can make decisions. The most simple of these is the IF function: it returns a value depending on whether a condition you describe is true or false. Once you get the hang of using the IF function, you will find it easier to us…

785 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question