macro

[Guest]

I protected my workbook and worksheet - but users can still see my macros.
Is there anyway to stop them from viewing my macros ?
Thanks,
Yosef

 

[Guest]

When in the VB Editor go to Tools, VB Properties, Protection, then click Lock
project for Viewing and assign a password.

Exit the editor, and save the xls file.

 

[JE McGimpsey]

In the VBA, choose Tools/<project> Properties, check the Lock project
for viewing checkbox, and enter a password in the Protection tab. Close
and reopen the workbook.

Realize, however, that this protection only keeps out the honest and
incurious - it takes less than a minute to bypass that protection if you
know what you're doing or are using a commercial cracker.

 

[Guest]

Thanks !

In the VBA, choose Tools/<project> Properties, check the Lock project
for viewing checkbox, and enter a password in the Protection tab. Close
and reopen the workbook.

Realize, however, that this protection only keeps out the honest and
incurious - it takes less than a minute to bypass that protection if you
know what you're doing or are using a commercial cracker.