I need some assistance with some excel VBA code I'm having issues with.
I have an excel workbook which has a user login when opened and then controls what sheets are visble.
The issue I have is the code I'm currently using only allows numeric for a password.
I would like the code changed to allow for passwords with letters and numeric
Attached a document with the full code and below is the part which checks the password. Currently when i have a password with letters in it just says worng password.
'Check the login and passcode for the administrator
If user <> "" And Not IsNumeric(user) And Code <> "" And IsNumeric(Code) Then
For Each AName In [login to view URL]("S8:S35")
'If AName = Code Then ' Use this for passcode text
If AName = CLng(Code) And [login to view URL](0, -1) = user Then ' Use this for passcode numbers only
This is urgent so if anyone can help please get in touch.
9 pekerja bebas membida secara purata £15 untuk pekerjaan ini
Hello John, I am Luis from Venezuela and it will be my pleasure to assist you in this project. Relevant Skills and Experience Excel and visual basic Proposed Milestones £12 GBP - job done Please contact me by chat