View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
ordnance1 ordnance1 is offline
external usenet poster
 
Posts: 52
Default Password in a macro

I have a macro which requests a password before allowing one to change a
worksheet. I do not want the password to be case sensitive. My code follows:

On error GoTo Error
If TextBox1.Text < "groupproject" Then
Unload UserFormPassword

GoTo Error
Exit Sub
Else Unload Password_UserForm
New_Or_Edit.Show

End If
Exit Sub
Error:

Unload Password_UserForm
Invalid_Password.Show


What can be done to make this NOT case sensitive?