Encrypt Macro in a workbook

[flakedew]

I need to encrypt all the macros i have used in a workbook, so that users cannot see them
Is it possible?
Any help please

[macropod]

If you want to stop (most) users accessing your code, simply protect the workbook's code module. If you don't want users to be able to see that the macros are there, you can prefix their names with 'Private' or you could add a dummy parameter (eg Sub MyMacro(Optional Dummy As Boolean)). To hide a whole module, you can add 'Option Private Module' at the top of the relevant code module.

If you want to prevent users accessing the macros dialogue, you could use the following sub:

Please Login or Register  to view this content.

So many possibilities ...

[flakedew]

Thanx a lot