+ Reply to Thread
Results 1 to 5 of 5

VBA- password reset project

  1. #1
    Registered User
    Join Date
    04-10-2012
    Location
    Manila, Philippines
    MS-Off Ver
    Excel 2003
    Posts
    1

    Talking VBA- password reset project

    Hi! I am not an expert and these forums really helped me a lot when I make projects (copy paste it and just hope that it will work! lol) Anyway, I have a new project where employees need to log in and out of the workbook with their own log ins and passwords where I just used the MATCH formula for so that can access the hidden sheets that are only allowed for their own access. However, I need to create something for them to do a password reset. I don't want them to always give me their passwords as it is weird and would take so much of my time. So what I did was I created a sheet for them to place their new password ("PASSWORD CHANGE" sheet) then I created another sheet where their passwords are stored ("PASSWORD LIST" sheet) which only has A column - Employee Number and B column - their passwords. If the employee puts the password that they want on the PASSWORD CHANGE sheet, they just have to click a button and the macro will automatically copy the new password and paste it on the PASSWORD LIST sheet beside their respective employee number. Easy to explain how it should work but I don't know if this is possible. Thanks in advance for your help!!!

  2. #2
    Valued Forum Contributor dotchiejack's Avatar
    Join Date
    05-21-2015
    Location
    Antwerp,Belgium
    MS-Off Ver
    2016
    Posts
    507

    Re: VBA- password reset project

    Like this?
    The employees have to fill in all 3 fields and the passwords have to be identical or they can't proceed.
    In the password sheet you can enter the employee numbers in column A of the Passwords sheet and the combobox will be updated automatically.
    I use a table and a defined name range.See Formulas -> Name Manager.
    Attached Files Attached Files
    Click the * Add Reputation below to say thanks.

  3. #3
    Forum Guru Kyle123's Avatar
    Join Date
    03-10-2010
    Location
    Leeds
    MS-Off Ver
    365 Win 11
    Posts
    7,238

    Re: VBA- password reset project

    Why don't you just check their user id and forget about the password? Allowing users to choose passwords and save them in a workbook is a very, very bad idea...

  4. #4
    Forum Expert torachan's Avatar
    Join Date
    12-27-2012
    Location
    market harborough, england
    MS-Off Ver
    Excel 2010
    Posts
    4,295

    Re: VBA- password reset project

    Hi beebeng007,
    Extracted from one of my apps.
    No password is 100% secure, however they do stop little fingers idly meddling.
    The process is 'ADMIN' controlled, the administrator is the first person to individualise their password.
    Then the administrator is the only person able to access all passwords in the event an employee suffers a 'memory event'
    If an employee can remember their old password they can reset their own to a new password.
    All are originally set at 'PASSWORD' at initialisation.
    All records go to a 'Very Hidden' Sheet(PW). Very little point in password protecting workbook if numerous people need access.
    torachan.
    Attached Files Attached Files

  5. #5
    Forum Guru Kyle123's Avatar
    Join Date
    03-10-2010
    Location
    Leeds
    MS-Off Ver
    365 Win 11
    Posts
    7,238

    Re: VBA- password reset project

    The problem with this and letting users choose their passwords is that of reuse, they'll use the same password for more than one thing.

    You're then storing it in an extremely insecure way that anyone can access, you aren't even hashing it.

    There just isn't a good reason for doing it and very bad things can happen

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. [SOLVED] monthview error - this action will reset your project, proceed anyway?
    By dmcgov in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 04-01-2019, 06:57 AM
  2. Automated email for password reset.
    By SGT in forum Access Tables & Databases
    Replies: 1
    Last Post: 05-29-2014, 07:13 AM
  3. [SOLVED] Need a Macro for reset (remove selected range data) our project sheets
    By santosh226001 in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 01-16-2014, 06:15 AM
  4. This Action will Reset your Project
    By Winon in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 04-05-2011, 06:35 PM
  5. this action will reset your project?
    By e.good in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 02-27-2011, 12:40 PM
  6. Reset project on open?
    By geoB in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 03-25-2009, 09:59 AM
  7. [SOLVED] OLEObjects.ADD causes excel vba project to stop / reset / go dead
    By Timothy Marks in forum Excel Programming / VBA / Macros
    Replies: 12
    Last Post: 12-03-2005, 01:10 AM

Tags for this Thread

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1