macro

Y

ynissel

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
 
C

cincode5

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

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

ynissel

Thanks !

JE McGimpsey said:
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.
Click to expand...
 
Top