View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.programming
JE McGimpsey JE McGimpsey is offline
external usenet poster
 
Posts: 4,624
Default Preventing User Access to VB code

You've been given an answer for how to password protect you code.
However, you should know that this password protection provides only a
slight amount of real protection.

Anyone with enough gumption to find these newsgroups can find multiple
ways to bypass your restrictions. Usually with only a few seconds' work.

Excel's internal protection isn't worthy of the name. Instead, you may
want to consider protecting your code by including it in a compiled COM
add-in.



In article ,
halem2 wrote:

is there a way to prevent user access (password?) to the VB code in an
Excel workbook?

I have already restricted the tool bars and menu but I would like to
prevent users from trying to see the VB code.