Hi,
could please anyone help me with the following issue.
I use the following code to validate a user as an approver, but I noticed that if I put the name jsmith (which is on the user list) and then try to put the jsmit (which it should not accept), it accepts both.
Could anyone please help. Thank you in advance!
Code
With Worksheets(1).Range("A2:A" & Range("A65536").End(xlUp).Row)
Range("B1").Value = nm
Set c = .Find(nm, LookIn:=xlValues)
If Not c Is Nothing Then
Call Authorized_User
wkbk.Close SaveChanges:=False
MsgBox "Use DRC Report Menu to Upload DRC Data", vbInformation, "Information"
Else
wkbk.Close SaveChanges:=False
MsgBox "You are not authorized to change the file", vbInformation, "Information"
Display More