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!!!
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!!!