Excel User Login/User Control Panel

[Oliver]

Hello everyone,
Please look at my attached file for reference.

Login_Extract.xlsm

I've been working on a login and user control panel for a project and I want to do the following:
Assign roles, add new users, deactivate/archive users, and lastly full functionality of the login form.

* So far I have some accomplish. A clear one that I cant figure out is when I click on the drop down to pick the user nothing comes up, so what I've been doing is typing in the username and the password each time. (I changed the background color of the usernames so you guys can try the login.)
*The other thing I need help with is the archiving portion, I will like to remove the name from the users list and place those names in on a different sheet for tracking purposes.

[HansV]

The RowSource of ComboBox1 on Login_Form is TMS, but that is not a valid range name.

Where do you want to archive users to?

[Oliver]

On the full workbook I have a sheet "archived" that I'll use to place those names.

[HansV]

You already have code to find the user on the loginid sheet.
Copy the cells in columns A to E to the archived sheet, then delete those cells (shifting cells up).

[Oliver]

Thank you!

[Oliver]

Hans, I just realized that when I click on a different open workbook it focuses on the login form if the user hasn't logged in.

I tried the following:
On Workbook_Deactivate

Code: Select all

Login_Form.Hide

On Workbook_Activate

Code: Select all

Login_Form.Show

It works if you open a workbook while the login form is showing, but if I click an existing open workbook it doesn't allow it.

[HansV]

I'm afraid I don't know, sorry.

[Oliver]

Thanks, Hans. I'll see what I can do.
I want the users to do everything as usual if they're not using my stuff.

....Not doing so is a violation of good interface design and a cause of confusion and irritation.