+ Reply to Thread
Results 1 to 3 of 3

Username and Password Form

  1. #1
    Registered User
    Join Date
    12-10-2012
    Location
    Coventry, England
    MS-Off Ver
    Excel 2003
    Posts
    2

    Username and Password Form

    I've been tasked with creating an Excel-based report that will be sent to a number of individual business partners, but rather than send a number of separate versions I'd instead like the data included within to be governed by a Username and Password login form.

    The form itself will only dictate access to the report. I can amend the data available to the user with VLOOKUP's etc. provided that this can reference a cell which shows the 'logged-in' user.

    I have little-to-no VBA programming experience but am under some pressure to produce the report in this way. With this in mind, I'd very much appreciate some assistance with the following:

    Providing the relevant code that will allow me to create a Username and Password form, where Usernames and Passwords are stored (by me) in a separate "Very Hidden" sheet. The 'logged-in' user should be stored in a cell on a hidden sheet - potentially the one containing Usernames and Passwords for ease.

    Any assistance you can provide would be much appreciated.

  2. #2
    Registered User
    Join Date
    01-24-2013
    Location
    Toronto, On, Canada
    MS-Off Ver
    Excel 2010
    Posts
    1

    Re: Username and Password Form

    I am also looking for a similar VBA. One workbook with 40 or more sheets, each sheet accessed by individual users with individual passwords.
    I would like a table containing the username and password to be referenced by the userform, if the wrong credentials are entered an error message is displayed.
    I've searched the forum and can't find anything. I have relevant posts but nothing quite fits what I'm looking for.

  3. #3
    Registered User
    Join Date
    09-25-2009
    Location
    san antonio, tx
    MS-Off Ver
    2007
    Posts
    11

    Re: Username and Password Form

    i would be interested in this as well

    Tony

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

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