How to prevent anyone from viewing the code

[Guest]

Hi
I have created a tool and protected it. So now noone can change it but I want to disable anyone from even viewing it. How should I do it
TI
Shilps

 

[Mike Fogleman]

With the workbook open and the VBEditor open, on the VBEditor tool bar
select Tools/VBAProject Properties/ and then the Protection tab to set
whether it can be viewed and password.
Mike F

Hi,
I have created a tool and protected it. So now noone can change it but I

want to disable anyone from even viewing it. How should I do it?

 

[Don Guillett]

Perhaps you should also know that this doesn't take effect until you save
the workbook>close>re-open.

 

[Guest]

Thanks