C
ChrisPisani
Imagine you are a company and have an excel file, but only want staff to
even view the worksheets.
I have an excel file with some data, I hid all the worksheets in a way
so you cannot unhide them by using: Format, Worksheets, Unhide. The
only way of unhiding them is through VBEditor. The VB Project is also
protected by a password.
I have made 2 new sheets, one was added to the completly hidden list of
worksheets and the other is the first and only worksheet one can view.
In this sheet I have made a place where they can wright only their
username and password. In the 2nd worksheet (the one that is hidden) I
put a list of all the usernames and their passwords.
My question is: is there a way that if the username and password are
correct (using LOOKUP and IF formula), some worksheets will appear from
the hidden list.
eg: if username = John and his password = 455
When he enteres username John and password 455, certain worksheets (or
all) will be visable
Attached is rough example I created now (the worksheets are not yet
hidden and no passwords are needed)
Please reply, I would really like to know.
PS: If you know of any website that has free downloads of excel
programs please let me know, I always enjoy having several programs for
everything I have.
Thank You very much
Chris
+----------------------------------------------------------------+
| Attachment filename: example.xls |
|Download attachment: http://www.excelforum.com/attachment.php?postid=364845|
+----------------------------------------------------------------+
even view the worksheets.
I have an excel file with some data, I hid all the worksheets in a way
so you cannot unhide them by using: Format, Worksheets, Unhide. The
only way of unhiding them is through VBEditor. The VB Project is also
protected by a password.
I have made 2 new sheets, one was added to the completly hidden list of
worksheets and the other is the first and only worksheet one can view.
In this sheet I have made a place where they can wright only their
username and password. In the 2nd worksheet (the one that is hidden) I
put a list of all the usernames and their passwords.
My question is: is there a way that if the username and password are
correct (using LOOKUP and IF formula), some worksheets will appear from
the hidden list.
eg: if username = John and his password = 455
When he enteres username John and password 455, certain worksheets (or
all) will be visable
Attached is rough example I created now (the worksheets are not yet
hidden and no passwords are needed)
Please reply, I would really like to know.
PS: If you know of any website that has free downloads of excel
programs please let me know, I always enjoy having several programs for
everything I have.
Thank You very much
Chris
+----------------------------------------------------------------+
| Attachment filename: example.xls |
|Download attachment: http://www.excelforum.com/attachment.php?postid=364845|
+----------------------------------------------------------------+