ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   vba code protection (https://www.excelbanter.com/excel-programming/346760-vba-code-protection.html)

Paul

vba code protection
 
In an addin, I am wondering if the following procedure would give good
security to the VBA macro code:

1. strong password
2. If Not ThisWorkbook.IsAddin Then ThisWorkbook.Close SaveChanges: = False


If this is not secure, perhaps there is a way to do the same thing if anyone
uses the correct password.

Anyone have an opinion --- suggestion??


Dave Peterson

vba code protection
 
Project passwords can be removed without using excel.

Event procedures can be turned off at will.

I don't think that there is a way to really protect your Addin if you write in
in VBA.



Paul wrote:

In an addin, I am wondering if the following procedure would give good
security to the VBA macro code:

1. strong password
2. If Not ThisWorkbook.IsAddin Then ThisWorkbook.Close SaveChanges: = False

If this is not secure, perhaps there is a way to do the same thing if anyone
uses the correct password.

Anyone have an opinion --- suggestion??


--

Dave Peterson


All times are GMT +1. The time now is 08:51 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com