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??

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