Is there a way to protect vba code from viewing ?

No absolute way - let's face it, if you have a computer, someone could break the security, and especially with MS Office products. However, the most common way of protecting the code (from 99% of the people who use Excel/Word) is this:

1. In VBE goto Tools | VBE Project Properties...

2. Select the Protection tab

3. Check the box for "Lock project for viewing"

4. Input and confirm your password

5. Save and close the workbook

Oh yeah, and remember your password!

For what it's worth, last week my boss locked himself out using this method (and forgetting his PW.) Took about 5 minutes on Google to find a utility to reset the password.
So 99% might be more like 97%

quot et demonstratum

Thanks, it works

FWIW - I like to separate my code from the data. This way I can hide the code file from view and have it open as read-only (since it is fixed code it will not be updated during use) With the file hidden it will not show in the workbooks list. I keep master copies of programs so if something gets altered I can replace it quickly.

Password protection and saving as a .xla gives more protection, but for internal stuff hiding and using read-only works good without having to keep up with passwords.

Here's utility code I use to to hide, save, and close a code file after I've finished editing and testing.


/