Excel Secure VBA code from Prying Eyes

[Ben]

Hi

Is it possible to secure the VBA code in Excel from anyone reading it?

Any advice would be much appreciated

Thanks

B

 

[Upendra Agnihotram]

There is an option to password protect ur VBA Code.
On the Project Properties box you will see a tab called protection.
You need to select "Lock Project for viewing"

and you need to give the password and also you need to confirm it in the
below provided text boxes.

Please remember that you can view this option when you are using Excel 2000
or above version only.

Regards--Upendra

 

[Tushar Mehta]

In the VBE, from the Project Explorer pane, right-click the project and
select {project name} Properties... | Protection tab. Follow
directions.

Keep in mind the password will apply to you too.

Also keep in mind the password protection mechanism is good to keep the
casual person out. In other words, security is easily broken.

--
Regards,

Tushar Mehta
www.tushar-mehta.com
Multi-disciplinary business expertise
+ Technology skills
= Optimal solution to your business problem
Recipient Microsoft MVP award 2000-2005