Help with Multiple Users

[tripppin]

Hi, I did some searching but did not find what I was looking for. Sorry if this has already been answered.
I want to make a log in excel that will auto-fill certain areas. The only problem is legally it needs to have restricted access/ the ability to prove they modified the log. The perfect situation would be 10 users, each user has their own individual password and depending on who logs in will dictate how the form can be filled out. Like once they put in their password the only initials they can enter are theirs.
Another option is that excel would put a "Last Modified by" comment with the persons user name each time the workbook is modified on the tabs that were modified. This would document that a user under an permitted login modified the document.

I am very familiar with excel, so would like to continue with it and not learn another program. Is this possible in excel or should I be looking in another direction?

Thanks in advance

 

[Candyman8019]

This is possible and there are several threads on this board about it. Long story short...nothing in Excel can be kept from someone who knows what they're doing...but for general users this can be accomplished.
Here's a little something that I've been working on.

OneDrive

Sign in to your OneDrive cloud storage and Office Online.

1drv.ms

This sheet will require users to log in and only see specific sheets. It is partially based on concepts from others…then I took it a few steps further.

Some of the features include:

• It will default to the username of whoever is logged into the computer.
• Users are allowed 3 attempts to log in before the app closes.
• Users cannot close out of the login form.
• Users and administrators can be defined within the application.
• Users and administrators can change their passwords for the apps.
  • Passwords can be alphanumeric. No other restrictions have been put in place.
• Successful logins are tracked for audit purposes.
• Logged in user is shown in the status bar.
• Administrators define which tabs a user can see. The rest are automatically hidden.
  • This is currently set to allow up to 6 sheets for each user.
• As new tabs are added (or names changed), an administrator can trigger an update to the data validations used for allowing users to see specific tabs. Alternatively, it will update the next time the sheet is opened.
• Users will not be able to unhide sheets on their own. They will only see what the admin allows them to see
• ‘SaveAs’ is only allowed for Admins. Users can only save.
• The VBProject is locked.
• There is a recovery feature where if the admins forget their password, they can still log into the app to update passwords, edit the workbook and get the password for the VB project.
• Upon closing the app, all tabs are hidden to get ready for the next user to open the app and log in.
  • In case the app crashes before tabs are hidden, they will also be hidden upon opening the sheet.

As you're using it, if you think of other useful features, I'd love to hear about them to create the next iteration of this.

admin ID and pass: Joe / 9999
Recovery pass: Superadmin / AdminPass

 

[tripppin]

That's great, nice build! I'm going to attempt something similar, but with a user dashboard. This will fill in areas of separate sheets with a date/time/username depending on what checkbox is selected from the dashboard. Save some time at work writing everything out.

Thank you for the example. Can share a demo of mine once I get time to work on it.