Thanks Thanks:  0
Likes Likes:  0
Results 1 to 3 of 3

Thread: Password Setup

  1. #1
    New Member
    Join Date
    Mar 2002
    Posts
    17
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    Hi all,
    I have searched the board and have not found exactly what I am looking for so here goes. Upon opening a workbook (with about 30 sheets) I would like a message box to prompt the user for a user name and password (there will be around 50 users). Based on the username (and correct password) I would then like to give different users different access to worksheets based on what I have defined they can view. (For example I would like user1 to be able to view worksheets a, b, & c, and user2 to be able to view worksheets b,c, d, etc....)

    I have created a simple username and password prompt, and can probably figure out some very inefficient code to do all this, but perhaps someone can give me a clean way to put this together. My first thought was to have a 'User Access' worksheet, with Username in column A, password column B, and then list the 50 worksheets, putting an x if they have access to the sheet and an o if they do not. Not sure how to set up the code though.

    Thanks!!!

  2. #2
    New Member
    Join Date
    Mar 2002
    Posts
    17
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    An addition,

    I have seen the post by y2k on 03-06 which covers the same issue. Am looking for more insight into the precise and efficient coding that Dave Hawley refers to.

    Thanks again.

  3. #3
    New Member
    Join Date
    Mar 2002
    Posts
    17
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    Any thoughts? Should I rephrase?

    Thanks!

Some videos you may like

User Tag List

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

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