View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.programming
Simon Murphy[_2_] Simon Murphy[_2_] is offline
external usenet poster
 
Posts: 45
Default VBA Passwords - security

File open passwords and the underlying encryption are pretty good in
later versions of Excel.
The rest is more a usability feature than security.
Accessing hidden/protected VBA code is completely trivial in many tools
and applications.
Excel and VBA are not designed to be secure, if you really need that
consider other technologies.

Cheers
Simon
Excel development website: www.codematic.net



Neptune Dinosaur wrote:
G'day

I'm asking this question as a serious Excel/VBA developer rather than as a
potential mischief-maker (thought I'd better make that clear).

I know that it is possible for someone to crack an Excel Protection password
with 3rd party software, but how about the password that you use to hide the
VBA editor? Can that be cracked?

Don't tell me how, just tell me how to avoid it if it can be avoided.

Thanks doods