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 [url removed, login to view]("S8:S35")
'If AName = Code Then ' Use this for passcode text
If AName = CLng(Code) And [url removed, login to view](0, -1) = user Then ' Use this for passcode numbers only
This is urgent so if anyone can help please get in touch.
10 freelancers are bidding on average £15 for this job
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
Hi , I am interested by your offer: Excel VBA code. Let me know more details of this work. I will start working immediately :) Br; Relevant Skills and Experience VBA Proposed Milestones £21 GBP - VBA