Hi,

You can lock you VB project for viewing and this will give a measure of
security but anyone with a small amount of experience would still be able to
look at your code.

Excel protection is really only to reduce the risk of inadvertant or
accidental change and provides only minimal security.

The correct syntax is password:="123"


Mike

"Partly Void" wrote:

The macro will run on a password protected sheet with Unprotect
Password:"123" but the actual password is clearly available to the user. Is
there a way to hide the password?