Excel macro protect problem

Z

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
 
A

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.
 
J

Joel

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

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top