Excel VBA code to handle passwords

£10-20 GBP

Đã hoàn thành

Đã đăng vào

gần 7 năm trước

£10-20 GBP

Thanh toán khi bàn giao

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

Mã dự án: 14380111

Về dự án

9 đề xuất

Dự án từ xa

Hoạt động 7 năm trước

Bạn muốn kiếm tiền?

Địa chỉ email

Lợi ích khi chào giá trên Freelancer

Thiết lập ngân sách và thời gian

Nhận thanh toán cho công việc

Phác thảo đề xuất của bạn

Miễn phí đăng ký và cháo giá cho công việc

Đã trao cho:

@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 trong 1 ngày

4,9

(8 nhận xét)

4,4

9 freelancer chào giá trung bình £15 GBP cho công việc này

@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 trong 0 ngày

5,0

(108 nhận xét)

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 trong 0 ngày

4,8

(39 nhận xét)

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 trong 1 ngày