Greg,

To password protect the code, go to the VBA Editor
Tools/Project Properties/Protection
check "lock project for viewing" and enter a password.
While doing this may thwart the casual user, someone
proficient in Excel (or just about anyone with access to
these ng's or Google) can find methods to unprotect
your project and view the code.

You mentioned hiding sheets.
You can do this via VBA by making the sheets "VeryHidden"
(meaning that they won't appear on the Format/Sheet/Unhide
menu). Again, if the user does get into your code, they'll
be able to unhide the sheets.

In summary, you can do what what you asked but it's not as
secure as it might seem. It all depends on the knowledge
and expertise of the user(s) that you're trying to protect
your work from.

John

"Greg_Del_Pilar" wrote in message
. ca...
Hello!

I write VBA code to automate certain functions in my Excel file, and I use
a
lot of "template" sheets to generate charts and save them as a new xls
file.
My client wants to run my programs on their site, which requires that I
give
them a copy of the main Excel workbook that contains my templates and VBA
code. Is there any way for me to hide them so that my client cannot copy
my
code? Ideally, I want to be able to password-protect everything in my
file.
(The client really just has to press the keyboard shortcut --- CTRL-M ---
to
run my main routine.).

Thanks for your help.

Greg