Userform to open specific worksheet

[ezonemy]

hi,

im newbie in macro. trying to create a workbook which contains multiple sheet. I need userform with textbox for user to key in their user id which will open a specific worksheet tied to that user id. Other sheet must remain hidden.The userform must be auto open when the excel is opened and disappear once specific worksheet opened. 1 admin user id which enable to edit the user id list and all sheet must be visible for this admin id only.

Pls help, thanks alot.

 

[mikerickson]

I think that Post #3 in the link has what you want.
user wise sheet rights only for view

 

[ezonemy]

Thank mikerickson will try the workbook given