Back Button in excel

[squidge1990]

when a user logs in it will store there security level in a public variable called level. im trying to use this so that i can create a back button to instead of going back the login screen it will go back to the users switchboard. but the code doesnt seem to be reading from the variable.
heres the code of the back

Private Sub back_Click()
If level = low Then
Worksheets("Lowlev").Visible = True
Worksheets("Lowlev").Select
End If
If level = Mid Then
Worksheets("MidLevel").Visible = True
Worksheets("MidLevel").Select
End If
If level = high Then
Worksheets("HighLevel").Visible = True
Worksheets("HighLevel").Select
End If
Exit Sub
End Sub

i would be very thankful for anyones help

[albertw]

i would be very thankful for anyones help[/quote]

hi
i should do this differently use Case instead

Private Sub back_Click()
Select Case Level
Case is = low
Worksheets("Lowlev").Visible = True
Worksheets("Lowlev").Select
Case is = medium
Worksheets("Mediumlev").Visible = True
Worksheets("Mediumlev").Select
Case is= high
Worksheets("Highlev").Visible = True
Worksheets("Highlev").Select
End Select
End Sub

declare the variables Level, Low, Medium and High in your general declaration if you want them to be available in your form, or in a module if you want them in the entire project.