How Protect Source Code from User on Excel Macro

[antoni]

Hello, how to protect source code from user or give the password when the user view code, right click on a sheet.

thank's

[royUK]

Do you mean stop the user seeing the code in the VB Editor? If so

In the VB Editor

Tools -> VBAProject properties.

On the protection tab you can add a password & check the Lock project from Viewing box.

You must save 7 close the workbook before this will take effect. Do not forget the password because you will not be able to access the code without it.

See http://www.excel-it.com/video_tutori...A_Password.swf

[antoni]

Hello Mr. Roy, thank's for your helps.

[D_Rennie]

Hello antoni.

Excel security is very weak and will not stop people from cracking the code (usally take but a second with the right tools)
So just keen in mind that passwords withen excel are only there to help prevent the viewing of code. and will not keep it secure.

[antoni]

Ok Bos.. thank's for your Advice and your Attention.
But I believe Excel is Excellent and is the best, and no one can crack it. Hohoho