Prompt For Password On Cell Entry

Hi,

I am trying to password protect user input on a specific text entry, for example if a user tries to enter the letter A they are prompted they require a password (I am trying to do this for authorisation.).

Thanks.

Re: Password Protect User Entry

Quote from Simon Lloyd

Will the worksheet be already protected? what does entering a password do?, what are you expecting to happen when a prompt for password is given?

Hi,

Thanks for your reply.

The workbook will be protected.

Entering a password would enable the user to input the letter A for example.

Basically, Im trying to create a rota / hours manager for employees and on this occasion if they enter the letter H they can't as this would indicate holiday. they need authorisation to book off holiday.

Thanks in advance.