Hi Matt,

On an unprotected sheet is there any way to stop a user entering a formula
"=Password" and / or to stop "Password" appearing in the Named Range drop
down list?


Range("password").Name.Visible = False

will remove the name from the dropdown list.

I do not know how to avoid using "password" in a formula, except that you
use a name that cannot be guessed by the user. If the range is in a
hidden/protected sheet there's no way to find out what the name is. So make
it something like "myRngPWord!".

arno