+ Reply to Thread
Results 1 to 5 of 5

Creating Multiple User Screen

  1. #1
    Forum Contributor
    Join Date
    08-18-2017
    Location
    india
    MS-Off Ver
    2010
    Posts
    490

    Creating Multiple User Screen

    Hey Guys,

    I am not able to work on this.

    I need to create a login screen on excel.

    There are 10 users who use the excel file.

    So i want to give them all a different user ID and a password so that they can enter to access the excel file.

    How do i do that using VBA?

  2. #2
    Forum Expert BadlySpelledBuoy's Avatar
    Join Date
    06-14-2013
    Location
    East Sussex, UK
    MS-Off Ver
    365
    Posts
    7,468

    Re: Creating Multiple User Screen

    We will need more information than that.

    What is the purpose of 'logging in'? Is it to restrict access to only those 10 users or to identify who has made changes to data?

    Will each user have their own sheet to work on or will they all update the same?

    Will there be a need for simultaneous multiple user access to the file?

    Could you attach a desensitized sample workbook?

    BSB

  3. #3
    Forum Contributor
    Join Date
    08-18-2017
    Location
    india
    MS-Off Ver
    2010
    Posts
    490

    Re: Creating Multiple User Screen

    Hey,
    thank you for your reply

    There are 10 people who use the excel file to enter product details and make invoices.

    Product details are enterted in Sheet "Product"
    Invoices are made through Sheet "Invoice".


    So I basically want to track who makes invoices, who enters product details.

    This is to ensure that they dont blame each other when there is a problem with invoicing and products.

    I have a sheet "tracker" which tracks few details when a user makes invoices and enters product details.


    I want to make the security tight for the file.

    I have attached the sheet.
    Attached Files Attached Files
    Last edited by anilpatni1234; 07-01-2018 at 07:39 AM.

  4. #4
    Forum Expert BadlySpelledBuoy's Avatar
    Join Date
    06-14-2013
    Location
    East Sussex, UK
    MS-Off Ver
    365
    Posts
    7,468

    Re: Creating Multiple User Screen

    If you're already using VBA to record information why not use Environ$("UserName") to record that too?

    If file security is a requirement here then be warned that Excel is NOT very secure at all.
    If I were one of your staff and wanted to change data to blame someone else for something, it would take me seconds to break the protection you put in place.

    BSB

  5. #5
    Forum Contributor
    Join Date
    08-18-2017
    Location
    india
    MS-Off Ver
    2010
    Posts
    490

    Re: Creating Multiple User Screen

    Hey sure. Thanks.

    I would try that.

    Thank you for guiding.

+ 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] Creating multiple user forms based on a single data table
    By eHektor in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 09-16-2016, 06:06 AM
  2. Help creating multiple user entry forms into a database
    By jacobkmc in forum Access Tables & Databases
    Replies: 2
    Last Post: 03-12-2012, 12:05 PM
  3. Replies: 0
    Last Post: 12-14-2011, 02:28 PM
  4. Creating a log in screen with user name and password
    By jermaindefoe in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 11-15-2007, 06:18 AM
  5. prevent user moving form on screen
    By memphis in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 10-09-2007, 05:23 PM
  6. Creating a conditional screen based on multiple criteria
    By Paul987 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 02-28-2006, 01:35 PM
  7. How to make user forms FULL SCREEN?
    By Fendic in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 06-24-2005, 02:05 PM

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