VBA - Run only for specific users

[honger]

Hi All,

I want to run an event for specific user. In this case, only John Doe should be able to run this command. It works fine if i put john doe in there and i get the MSGBOX since my windows log in is not John doe. But when I put my windows login there (and only I can run it), i dont get any msgbox or the rest of the command does not run....anyone can help me what I am missing? code in question is in red

Thanks all

Please Login or Register  to view this content.

[mc84excel]

Exit Sub should be within the If End If condition HTH

[honger]

thanks for the reply, i am getting compile error: End If without block If. Do i need to user Goto? to direct it to the first event for the user who has the right?

[honger]

thanks for your suggestion, im a beginner so i wrote it this way and it is working.

Please Login or Register  to view this content.

I got this solved, but how would i do it if i want to name multiple users whos have the rights?

[Trebor76]

Hi honger,

Try this for your initial code:

Please Login or Register  to view this content.

HTH

Robert

[honger]

perfect robert, your way works perfectly and i didnt have to rely on my clumsy method.

do you happen to know how i can name more than just one person?

[Trebor76]

do you happen to know how i can name more than just one person?

Maybe - the solution will be dependent on how may names we're talking about. Let me know that and I'll see if I can code something.

Robert

[honger]

3 people.....but i may have to add users down the line if the responsbility is given to more people.

Currentlyi have 25 in our group, but i only want 3 of them to have ability to run this. But i may have to give other the rights as well down the line.

But i will take a solution for just three people now!! thanks

[Trebor76]

OK - for a dataset of that size use this (just change the names to suit):

Please Login or Register  to view this content.

Just add the names you need to the varMyArray variable.

HTH

Robert

[honger]

beautiful!
i have a long way to go to do these on my own, thanks so much for all the help guys

[Trebor76]

thanks so much for all the help guys

You're welcome

If you could mark the thread as solved it would be appreciated.

Regards,

Robert