Multiple User Passwords for a Workbook???

**draco102000** · 12-19-2008, 07:08 AM

Is it possible to have multiple user ID's and passwords for a single workbook. I am trying to control who accesses and has editing rights to a workbook. The reason I would like to do something like user ID's and passwords is I have people that give out the password and if each user was unique it would prevent this problem! Thanks for any help or ideas!

**Richard Buttrey** · 12-19-2008, 07:15 AM

Hi,

There's no built in functionality to do this but you could program something similar. Set up a table of user names and passwords on a sheet which will be made 'veryhidden' in the VBE.

Then have a user input box which would ask for the users name and password. It would then check this password against the table of user names and passwords, and if correct allow the user to continue. If you password protect the VBE then a user wouldn't even be able to go to the VBE and unhide the password sheet.

HTH

**Dave Franciosy** · 12-20-2008, 04:18 AM

Morning
This is just what I was looking for
sorry to sound really thick but what is vbe
not been using excel long
thanks for any help

**shg** · 12-20-2008, 04:27 PM

Dave,

VBE is the visual basic editor.

Posting questions in other people's threads is verboten in this forum and most others I know of. Please get started on the right foot: take a few minutes to read the Forum Rules, and then start your own thread. Include a link to this one if you feel it's particularly relevant.

**JBeaucaire** · 12-20-2008, 10:00 PM

Originally Posted by draco

Is it possible to have multiple user ID's and passwords for a single workbook. I am trying to control who accesses and has editing rights to a workbook.

Yes, it's possible, definitely will require macros/VBA to accomplish.

Attached is a workbook I helped someone here on the forum create to do something similar to what you want. It asks for a password when opened.

Password = staff - you only can see Sheet1
Password = admin - all three sheets are visible and editable.

Something like this may be adaptable for your needs.

It uses macros during the workbook_open, workbook_save and workbook_close events. Even the macros themselves in the VBE are password protected (also admin if you decide to look at them.).

Originally Posted by draco

The reason I would like to do something like user ID's and passwords is I have people that give out the password and if each user was unique it would prevent this problem!

Good luck with that. I've found little stops people from giving out passwords, it's unbelievable. Your new sheet might stem the tide for a while, but eventually, the password grapevine starts again.

I hope you have better luck than I ever have. I eventually gave it up and started using tricks like the attached sheet to keep the REALLY important parts of the workbooks hidden away. Now my stress is less.

Good luck.

**shg** · 12-21-2008, 02:34 AM

You might match passwords with usernames. It would make it less easy to use someone else's password.

**jaygp89** · 04-01-2012, 10:20 PM

hi, i can't seem to be able to unlock your VBA to view the macros, please advise on this. I've tried your password "admin" many times but to no avail.

thanks!

**JBeaucaire** · 04-02-2012, 09:39 AM

There is no other password. CTRL-F11 to open the VBA editor, then click on the project and put in the "admin" password again.

**royUK** · 04-02-2012, 02:20 PM

This example contains a UserForm that asks for a password. The password can be different for individual users & access to specific sheets allocated. The form also allows for a password to be changed after logging in correctly