I have a worksheet with the Visible property set to xlSheetVeryHidden that
contains a Named Range, say "Password"

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?

Thanks

Matt