how can i protect the vba codes

[frsm]

dear friends
i have an excel workbook with many sheets and vba codes i dnt want any
one to recover the passwords and attack my work so i want any one to
help me in protecting the project spiecally the vba codes
with my full thanks for all the members
byeeeeeeeeeeee

 

[Dave Peterson]

Open the VBE
select your project
tools|VBAProject Properties|Protection tab

Give it a memorable password

Save the workbook, close the workbook and reopen to test it.

 

[Paul B]

frsm,
To protect the VBA project, from your workbook right-click the workbook's
icon and pick View Code. This icon is to the left of the "File" menu this
will open the VBA editor, in Project Explorer right click on your workbook
name, if you don't see it press CTRL + r to open the Project Explorer then
select VBA project properties, protection, check lock project for viewing
and set a password. Press Alt and Q to close this window and go back to your
workbook and save and close the file. Be aware that this password can be
broken by third party software
--
Paul B
Always backup your data before trying something new
Please post any response to the newsgroups so others can benefit from it
Feedback on answers is always appreciated!
Using Excel 2002 & 2003

 

[frsm]

hi friends
thank u alot for replay my question , and i want to say that iam new in
this great forum , but i am good in ecxell and i had disigned many nice
programmes by excel and vba codes
the problem that facing me is when i protect my sheets and vba codes in
the worksheet there are many hacking programes that can attack the
worksheets and can break the passwords that i made .
Iam searching away which can allow me to protect these codes and anyone
can't break the passwords

plz it is important for me

 

[Dave Peterson]

If your intellectual property is that important, then don't use excel. There's
nothing you can do to stop the theives from getting to your stuff.

Well, if you know anything about COM addins, you could compile your code. But
that's beyond me.

 

[leecs]

Hi,
Pls kindly let me know where to get any tools (FOC) to crack/hack
XL's VBA password? I have lock few file VBA been protected but
forgotten the password. (My password length should less than 10
digit).

Btw, I come across few XL VBA file which stated "Project is
unviewable" when I try to view it. May I know how can it be done?
Thanks.

 

[Dave Peterson]

I also think that intellectual property rights are important. I don't think
it's a good idea to tell people how to crack these passwords.