How can I get a sheet within a worksheet to be selected when entering the
name in an input Box.
For Example, I have a different sheet for each employee and I want then to
go to their sheet and enter daily information. Sheets for each employee is
hidden and password protected so when running the macro it will ask for your
name, once is entered it will ask for your password, if password is correct
it will open the sheet otherwise it will tell you Password incorrect. Is it
possible. thank you