Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
VBA Passwords - security
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Passwords | Excel Discussion (Misc queries) | |||
Passwords, Macro Security and Vs2007 | Excel Discussion (Misc queries) | |||
Passwords | Excel Discussion (Misc queries) | |||
Passwords | Excel Discussion (Misc queries) | |||
passwords | Setting up and Configuration of Excel |