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

  • Thread starter Thread starter Greg_Del_Pilar
  • Start date Start date
G

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
 
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.)
 
Back
Top