VBA Module Protection by hiding or password

[FM1]

I have asked this question before, and, the one or two responses given were general though much appreciated.

How can I protect the code in ONE single module from being accessed and viewed by the user in an EXCEL workbook and still have the VBA editor and other modules accessible.
Can a single module be hidden by using a "HIDE" method, property..ect. like a worksheet??

Thanks very much

FM

 

[asmenut]

No. There is not a way to hide an individual module. You can set a password protection to the VBA Project though. This will allow the developer the ability to access and manipulate the code while hiding the code from the individual users.

 

[Denial]

Depending upon what the to-be-hidden module contains, you might get some joy out of converting it to an add-in. Or, with a bit of restructuring of your code, you might be able to move key parts of it into an add-in.

 

[FM1]

Thank you