View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Dennis Tucker Dennis Tucker is offline
external usenet poster
 
Posts: 140
Default VBA Passwords - security

You can't hide the VBA Editor, but you can password protect the project
which if effect hides you code and prevents modification.

In the VBA Editor, in the project pane, right click on any of the sheets or
workbook in your project, select VBAProject Properties.... then on the
Protection Tab, check "Lock project for viewing" and add a password.
Save the Excel File.

Hope this helps

"Neptune Dinosaur" wrote in message
...
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
--
Time is just the thing that keeps everything from happening all at once