Protect Code

[Mike]

Hi. Is there a way to password protect my macro code?

Thanks,
Mike.

 

[David Coleman]

Hi Mike

Yup - in the editor, right click the "Modules" heading, choose "VBAProject
Properties" and fill in the details on the "Protection" tab - note, however,
that there are many bits of software out there that can crack these
passwords....

Regards

David

 

[Chip Pearson]

Mike,

In the VBA Editor, go to the Tools menu, choose VBA Project
Properties, then the Protection tab. There, check the "Lock
project for viewing" tab and then enter a password.


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com

 

[Mike]

Thanks, Chip!

-----Original Message-----
Mike,

In the VBA Editor, go to the Tools menu, choose VBA Project
Properties, then the Protection tab. There, check the "Lock
project for viewing" tab and then enter a password.


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com





.

 

[Mike]

Thanks, David!

-----Original Message-----
Hi Mike

Yup - in the editor, right click the "Modules" heading, choose "VBAProject
Properties" and fill in the details on the "Protection" tab - note, however,
that there are many bits of software out there that can crack these
passwords....

Regards

David





.