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.