Excel macro protect problem

[Zozi]

Hi,

I have problem.
How can I protect my macro project? I lock the macro but if I crack it
I can do that with Advanced Office 2000 Password recovery.
A would like to protect my excel macro. Somebody knows the best
solution?

Many thanks!
Zoltan

 

[akphidelt]

First of all if you have a macro that needs more security then the regular
VBE password then you must have one heck of a macro going. I don't know of
any other security measures you can really take. There might be, but I've
never seen or needed it.

 

[Joel]

If you need it that secure then create an addin. Buy a VB compiler and
create your own addin.

 

[Shane Devenshire]

Hi,

I'm going to take a guess that you mean by protecting the macro that you
have protected the Excel file with the macro.

to protect the macro itself move to the VB editor (press Alt+F11) and choose
Tools, VBAProject Properties, select the Protection tab, check Lock project
for viewing and enter and confirm the Password.