0 votes
in VBA by Beginner (2 points)
Suppose whenever We  done a professional project ie. micro enabled file  and this project in future we distribute  to other person but that person Resale this File to another person . Can we stop this problem through vba  coding?
by Beginner (65 points)
Do you mean: how to prevent that person from copying the file to his friend?

1 Answer

0 votes
by Skilled (489 points)

You can minimize piracy by using Unviewable+ to obfuscate an add-in that contains your macro.

Chris Newman (The Spreadsheet Guru) talks about it, here.

If you hire a professional developer to create an Add-in Express dll, that can help, too.

I use an add-in from Ken Puls called MonkeyTools. It was created with Add-in Express and, presumably, has some additional coding to handle licensing.

Another option is to port your project to .NET and make use of any robust protection schemes available for that platform.

Bottom line: you have to go through a lot of hoops to secure an inherently insecure workbook application.


Welcome to wellsr Q&A
Ask any questions you have about VBA and Python and our community will help answer them. wellsr Q&A is the standalone question and answer platform for wellsr.com. If you have a question about one of our specific tutorials, please include a link back to the tutorial.

Getting Started
VBA Cheat Sheets (On Sale Now)

Looking for something else? Hire our team directly through ourVBA Help page, instead.

For more programming tips visit the VBA Tutorials Blog and the Python Tutorials Blog.