View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Dave Peterson Dave Peterson is offline
external usenet poster
 
Posts: 35,218
Default 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