excel vba - set "if name = ?" password to show data

[chief]

I am trying to set up a command box in my "sheet1" excel spreadshee
that will prompt the person to give a password, and if the passwor
name of the person is correct then it will display the "prices" an
"totals" in the range "C3111 and H3:I111". If it is not tha
person's name, it will show the spreadsheet, but not the range jus
mentioned.

Is this possible or is there another method of doing this

 

[Bob Phillips]

It is possible, but where do you propose to store the information about the
users and the passwords> Can you not see a flaw here?

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)

 

[Dave Peterson]

And if you get this working, be aware that excel's protection isn't made for
security purposes. There's code posted here everyday that will unprotect any
worksheet.

If those prices cannot be shared, then excel is not your application.