Password Setup

GBOB · Mar 11th, 2002, 08:41 AM

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

GBOB · Mar 11th, 2002, 08:48 AM

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.

GBOB · Mar 12th, 2002, 10:17 AM

Any thoughts? Should I rephrase?

Thanks!

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Mar 11th, 2002, 08:41 AM	#1
GBOB New Member Join Date: Mar 2002 Posts: 17	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!!!

Mar 11th, 2002, 08:48 AM	#2
GBOB New Member Join Date: Mar 2002 Posts: 17	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.

Mar 12th, 2002, 10:17 AM	#3
GBOB New Member Join Date: Mar 2002 Posts: 17	Any thoughts? Should I rephrase? Thanks!