I am at a crossroads in writing some code for a workbook. I want to keep as much of this in code since the information in the hidden worksheet includes salary amounts. There will quite a few salaries listed so I thought it was best to have them on a hidden worksheet.
I want to create a userform that verifies a user password to unhide the sheet.
I don't know if I should put a vlookup on the hidden sheet or if there is a way to do the same thing in code. Again - I want to keep as much of this hidden as possible.
On sheet1 there will be a button to click - which opens the UserForm to enter the password. Range("F4") on sheet1 will be the user number that is keyed.
Here is my lookup range - the first set of numbers are the user numbers and the second set are the passwords. There are a total of 12 folks on the distribution list with user numbers.
10 = 5303
11 = 7712
12 = 8022
30 = 2415
36 = 5609
39 = 2902
40 = 2209
41 = 2424
42 = 0298
53 = 8703
54 = 8798
55 = 3160
The other part of this is depending on how the code is written - I need assistance in how to check the value of the textbox.text to the entered password.
Any guidance or suggestions would be appreciated. I started the process and have attached the basic format.