Excel VBA code to handle passwords

£10-20 GBP

Completed

Posted

almost 7 years ago

£10-20 GBP

Paid on delivery

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

Project ID: 14380111

About the project

9 proposals

Remote project

Active 7 yrs ago

Looking to make some money?

Email address

Benefits of bidding on Freelancer

Set your budget and timeframe

Get paid for your work

Outline your proposal

It's free to sign up and bid on jobs

Awarded to:

@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 in 1 day

4.9

(8 reviews)

4.4

9 freelancers are bidding on average £15 GBP for this job

@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 in 0 day

5.0

(108 reviews)

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 in 0 day

4.8

(39 reviews)

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 in 1 day