How to hide sheets and VBA code in my Excel workbook?

[Greg_Del_Pilar]

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

 

[Dave Peterson]

You can protect your code from within the VBE:

Tools|VBA Project Properties|Protection tab

But there are commercial password breakers that pretty cheap.

And you can protect worksheets by tools|protection|protect sheet

(but there's code posted here almost everyday that'll crack these.)