Protect and hide all macros in a worksheet

[Flaco]

Hi,
I put Option Private Module in the Module ... which removes all Macros from the list of macros ... but they are still visible if you press ALT-F11, Is there a way to hide/protect the code, so a user cannot see it at all? I have the workbook password in the code for example:

sheets.("Sheet1").Unprotect ("xxxx")

I don't want the user to see what the password is, so is there a way to hide the code so that the user cannot see it?

Thanks In Advance

[Sam.D]

In the left panel of the VBEditor, right-click on the VBAProject Properties and set security in there, add a password and save it.

Next time you open the sheet, the project is hidden even if the editor is opened. You will need the password to access it.

[chroma]

In VBA, Goto Tools-->Project Properties-->Protection-->Lock Project for Viewing.

Add a password to make sure that if anyone stumbles into VBA, they can't unlock the project.

Note that your macro list will be viewable and they can be executied from Tools-->Macros, but they cannot be edited.