Great and Thanks Alan for promp answering.

"Alan" wrote:

Obviously password protect the VB Editor, but 'Option Private Module' at the
beginning of the code stops the macro being visible at all. A user can run
it via a Button or whatever, but they can't see it.
Regards,
Alan.
"Iraj" wrote in message
...
Once again Hi all:
How can I hide the module or Part of VBA in a Macro that other user can't
see what I have done?