user input of password for username

**tinkerbelle** · 06-07-2012, 03:48 AM

Hi all,

I am designing a spreadsheet where the network username will identify each user who enters the spreadsheet.

I would like each user to be able to create a password the first time they enter the file, this would be saved on a worksheet called, for example, Passwords. Read access to this file should be via password only.

My questions are:

Can anyone help write the code to prompt the user to enter a password which would then save in the password sheet against their username.
The prompt would only be on their first time as after that it would be saved in the worksheet.

Saving on exit would require them to enter their password again, validation of this would be via looking up the password sheet.

Additionally, i foresee a problem with the password sheet itself being password protected. For example can Excel allow saving to this location via macro without the need to enter the password but not allow anyone to view the actual sheet without having first entered the password ?

Many thanks for all your help.

**lmvk99** · 06-07-2012, 05:36 AM

Are you defining the list of people that can set up a password? What about just using a master password that the macro will call up for saving the workbook only if it can see your name in the list. You don't really need passwords for individual users. The way to get around the needing to unprotect the sheet that holds the passwords is to a) hide but don't lock the sheet, b) protect the workbook (including structure) after you have hidden the sheet and c) don't ever try and select a cell on the sheet with your macro, just write to and collect data from it directly.

**tinkerbelle** · 06-07-2012, 12:13 PM

hi LMVK99,

The need for individual passwords is to limit what users can see. For example, user sw11 will only be able to see data relating to sw11 and not data relating to
aa11 or bb22.
I guess an alternative would be to make viewing sw11's records dependent on the windows username being sw11.

Any help gratefully received.

thanks