Protecting my Code

Hi all,

I have done a search and was unable to find the answer to my question, so any help will be appreciated.

I have written some code, which is going to be run my someone else.

The problem is i don't want them editing the code i have written as in the past, i allowed them to debug my code, but now, there is no need for them to debug it.

I have found that if i 'right click' on the module properties, then i can tick a box which says lock viewing and then type a password, the problem being if i then try to get them to run the macros, they get an error saying that it basically can't see the code.

Is there a way around this, ideally i would like to prevent them from even seeing the Code, but at least i want to stop them editing it.

Thanks in advance.

Normally if you lock a project from being viewed in a workbook the macro's will still run regardless, as the user is not trying to open the project, however if you incurr a problem and they click debug it will tke them to the password window. You should add error handling to take care of this.

Regards,
Simon