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

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


"ynissel" wrote:

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

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.

In article ,
"ynissel" wrote:

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

Thanks !

"JE McGimpsey" wrote:

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.

In article ,
"ynissel" wrote:

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