View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.programming
Mike H Mike H is offline
external usenet poster
 
Posts: 11,501
Default This one is For all the accomplished MVPs.

Is there no way to fully protect a VBA project?

No there isn't. Worksheet passwords can be cracked in moments with software
freely available using a Google search.

Workbook to open and project passwords are more difficult and generally need
commercial software to remove them but software such as found at the end of
the link below will remove a project password instantly.

The only way I'm aware of is to build you VB project using third party
software compiled outside of Excel but i know very little about that.

http://www.lostpassword.com/kit-standard.htm
--
Mike

When competing hypotheses are otherwise equal, adopt the hypothesis that
introduces the fewest assumptions while still sufficiently answering the
question.


"BEETAL" wrote:

Is there no way to fully protect a VBA project?

I have come across many comments in the excel programming news group which
say that it would take 30 seconds to un-protect a VBA project.

What is the best way to make the opening up the VBA project as difficult as
possible.

I was expecting that 2007 Excel vesrion would have the best possible
protection features.