vba code protection

[Paul]

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]

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