Excel VBA code to handle passwords

£10-20 GBP

Terminado

Publicado

hace casi 7 años

£10-20 GBP

Pagado a la entrega

Hi, 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. Thanks, John

Excel

ID del proyecto: 14380111

Información sobre el proyecto

9 propuestas

Proyecto remoto

Activo hace 7 años

¿Buscas ganar dinero?

Dirección de email

Beneficios de presentar ofertas en Freelancer

Fija tu plazo y presupuesto

Cobra por tu trabajo

Describe tu propuesta

Es gratis registrarse y presentar ofertas en los trabajos

Adjudicado a:

@SergeyKyiv

I already see what is needed to make it working with letters too Relevant Skills and Experience I have 20 years experience with MS Excel/Access/VBA: databases, finance, statistics, accounting, CRM etc. Proposed Milestones £15 GBP - ready working code Additional Services Offered £0.01 GBP - Client gets whole access and rights for the code I made. Warranty covers any bugs detected later.

£15 GBP en 1 día

4,9

(8 comentarios)

4,4

9 freelancers están ofertando un promedio de £15 GBP por este trabajo

@beltran0404

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

£12 GBP en 0 día

5,0

(108 comentarios)

5,4

@mhfsha

Hi, i just checked the description would be a pleasure To assist you on your project. Looking forward to discuss in the chat

£11 GBP en 0 día

4,8

(39 comentarios)

4,7

@prakash1317

I have done similar projects & confident to assist you. I'll take responsible to complete the work accurately & on time. Relevant Skills and Experience I have done similar projects & confident to assist you. I'll take responsible to complete the work accurately & on time. Proposed Milestones £20 GBP - payment once completed

£20 GBP en 1 día