Select Variable sheet name

[whcmelvin]

Hi this is my code. I want to select the sheet name that is the same as the login name. Each login name will have a sheet of its own.
i tried this code and i have error on Sheets(Variable).Select

Email = Sheets("Trading Platform").LoginName.Value
Variable = Email
MsgBox Email
Sheets(Variable).Select

 

[Richard Schollar]

Assuming Email is a variable, then you can use that directly:

Sheets(Email).Select

Do make sure that sheet Email is actually in the Active workbook and not another that you have open.

 

[trunten]

Hi, I'm a bit confused as to what you mean by login name. I'm going to assume that you don't mean their windows\network logon and that you have a named range somewhere which stores a "logon" name/id.

If that is the case then this should work.

Sub login()
    On Error Resume Next
    dim sheetName as String
    sheetName = Range("LoginName")
    With Sheets(sheetName)
        .Visible = True
        .Select
    End With
End Sub

 

[whcmelvin]

My excel sheet have a login function to allow user to login. so the excel have it own user. the login id is suppose to be thier email account. and every user should have a sheet name assign to them that will be named after their email.

 

[whcmelvin]

I have tried that code but it cant work. it gave me an error msg "Run-time error "9" Subscript out of range"

 

[Richard Schollar]

So what value are you using to select the sheet when you get the error? Is there a sheet in the activeworkbook with this name?

 

[Richard Schollar]

I have tried that code but it cant work. it gave me an error msg "Run-time error "9" Subscript out of range"

That's telling you there is no sheet in the Activeworkbook with the name held in the variable. How many workbooks do you have open, which is active and which contains the sheet that you want to open?

 

[whcmelvin]

eg, now my user is abc@gmail.com
so the Email is now abc@gmail.com and the msg box will show abc@gmail.com if i put msgbox Email
then i want to select the sheet abc@gmail.com cos each user will have the a sheet name after their email and is unique
the sheet name is now available in the workbook

 

[whcmelvin]

I only open one workbook.

 

[Richard Schollar]

So does the sheet exist in the workbook when you try and select the sheet? Or do you want the code to automatically create a new worksheet if it doesn't already exist?