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

Thanks,
Mike.

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


"Mike" wrote in message
...
Hi. Is there a way to password protect my macro code?

Thanks,
Mike.

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" wrote in message
...
Hi. Is there a way to password protect my macro code?

Thanks,
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" wrote in
message
...
Hi. Is there a way to password protect my macro code?

Thanks,
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


"Mike" wrote in
message
...
Hi. Is there a way to password protect my macro code?

Thanks,
Mike.


.