View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
swatsp0p[_39_] swatsp0p[_39_] is offline
external usenet poster
 
Posts: 1
Default Protect Excel VB macro


Are you protecting your VB code OR are you protecting the workbook?
These are different things... and different levels of security.

If you simply protect your worksheet/workbook via ToolsProtection, no
it is not secure from anyone with a slight desire to figure out how to
break the code. Also, it really doesn't matter how many alpha/numeric
characters you place in your password, Excel breaks it into its own
code, which is why it is so easy to break.

VBA protection, on the other hand, accessed through the VBA editor by
right clicking on the project you want to protect and choosing
'VBAProject Properties'Protection tab.

This password is encrypted and is NOT easily broken.

Good Luck


--
swatsp0p


------------------------------------------------------------------------
swatsp0p's Profile: http://www.excelforum.com/member.php...o&userid=15101
View this thread: http://www.excelforum.com/showthread...hreadid=480967