View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.programming
swatsp0p[_40_] swatsp0p[_40_] 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, n
it is not secure from anyone with a slight desire to figure out how t
break the code. Also, it really doesn't matter how many alpha/numeri
characters you place in your password, Excel breaks it into its ow
code, which is why it is so easy to break.

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

This password is encrypted and is NOT easily broken.

Good Luc

--
swatsp0

-----------------------------------------------------------------------
swatsp0p's Profile: http://www.excelforum.com/member.php...fo&userid=1510
View this thread: http://www.excelforum.com/showthread.php?threadid=48096