Excel VBA code to handle passwords

Closed

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 [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.

Thanks,

John

Skills: Excel

See more: code vba excel serial hard drive, simplex code vba excel, vba code clock excel sheet, vba excel code search bar, vba msproject code call excel, gnenerate xml code vba excel, vba excel toolbar code, code uninstall add vba excel, vba excel code extractor page web, vba excel ready code, vba excel code optimization, code vba excel primavera critical path, update code project excel vba, optimize code vba excel, vba excel code install add ins

Project ID: #14380111

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 Miles More

£15 GBP in 1 day
(5 Reviews)
3.1

10 freelancers are bidding on average £15 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 days
(50 Reviews)
4.7
£11 GBP in 1 day
(8 Reviews)
3.5
webanis

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

£21 GBP in 1 day
(13 Reviews)
3.8
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 More

£20 GBP in 1 day
(6 Reviews)
3.0
£18 GBP in 1 day
(1 Review)
1.1
davidsalah

hello i can provide you a good one for this project and i do all of the best specially i do more about VBA and i can do it now regard salah

£18 GBP in 1 day
(0 Reviews)
0.0
akshayagr666

A proposal has not yet been provided

£18 GBP in 1 day
(0 Reviews)
0.0
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 days
(0 Reviews)
0.0
AbdallahElYaddak

This task can be easily done. Relevant Skills and Experience VBA - Excel Proposed Milestones £10 GBP - Completing the task

£10 GBP in 1 day
(0 Reviews)
0.0