Solved

VBA strong protection software

Posted on 2014-10-02
3
203 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
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

Free Tool: Port Scanner

Check which ports are open to the outside world. Helps make sure that your firewall rules are working as intended.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

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

Do you use a spreadsheet like Microsoft's Excel?  Have you ever wanted to link out to a non excel file on your computer or network drive?  This is the way I found to do it!
This article describes how you can use Custom Document Properties to store settings and other information in your workbook so that they will be available the next time you open the workbook.
The viewer will learn how to use the =DISCRINV command to create a discrete random variable, use this command to model a set of probabilities and outcomes in a Monte Carlo simulation, and learn how to find the standard deviation of a set of probabil…
This Micro Tutorial will demonstrate how to create pivot charts out of a data set. I also added a drop-down menu which allows to choose from different categories in the data set and the chart will automatically update.

729 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