how to convert excel to .xls file

[Guest]

I am using a userform to get employees id number and passwords. I have the
id numbers and passwords on a hidden sheet. I need to code in the submit
button on the form a way to search the hidden sheet for there id number and
password match and then if it does match take them to a specific sheet.
Should I be going about this in a different manner or is this possible?

 

[NickHK]

One way is to have a WS with ID, PW and SheetName.
Do a VLOOKUP of the PW against the ID. If it matches, get the sheet name and
unhide.
You should be aware that Excel security is pretty easily broken, so if this
is very sensitive material, you should look for a more secure method, e.g.
use a database management system.

NickHK

"(e-mail address removed)"