Hi everyone
I have a list of users in sheet "USERS" that when I select a command button to open a userform it will look down the list and check the names against the application username. If the name matches then the form will open and if there is no match then a message box to say why you cant open the userform. The list of users needs to be open and I need to be able to maintain the list.
I can get it to work for a username in a single range but not read down a list. Suggestions welcome
Thanks miff3436
Bookmarks