Lengkap

Excel VBA code to handle passwords

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

Kemahiran: Excel

Lihat lagi: code vba excel serial hard drive, simplex code vba excel, vba code clock excel sheet, vba lock project for viewing, how to protect vba code in excel 2016, how to hide macro code in excel, excel vba password protect sheet, how to protect vba code in excel 2010, how to protect vba code in excel 2013, excel vba password protect macro button, protect vba code excel, excel, visual basic, microsoft excel, 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

Tentang Majikan:
( 95 ulasan ) Arlesey, United Kingdom

ID Projek: #14380111

Dianugerahkan kepada:

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 Lagi

£15 GBP dalam sehari
(8 Ulasan)
4.4

9 pekerja bebas membida secara purata £15 untuk pekerjaan ini

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 dalam 0 hari
(108 Ulasan)
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 dalam 0 hari
(39 Ulasan)
4.7
£11 GBP dalam sehari
(13 Ulasan)
3.9
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 Lagi

£20 GBP dalam sehari
(7 Ulasan)
3.2
£18 GBP dalam sehari
(1 Ulasan)
1.1
akshayagr666

A proposal has not yet been provided

£18 GBP dalam sehari
(0 Ulasan)
0.0
AbdallahElYaddak

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

£10 GBP dalam sehari
(0 Ulasan)
0.0
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 dalam sehari
(0 Ulasan)
0.0