Macro to run if only folder found...

[calvinle]

Hi,

I would like to know how is it possible to only run a macro with IF command if a path is found in a computer. My desktop user is example, jc855, and my coworker is jc886.
I would like to start the IF command such as, if
C:\Users\jc855 & C:\Users\jc886 found, then keep going, otherwise, message box : "You are not authorize to run this macro".
By having this path, people will be able to download this macro but the access is only granted if their user is added thru the VBA. (which only me can access to edit it).

Thanks for help.

[alansidman]

How about testing for the username, ie

Please Login or Register  to view this content.

[Jakobshavn]

Something like:

Please Login or Register  to view this content.

[calvinle]

How about testing for the username, ie

Please Login or Register  to view this content.

How this Environ username work? Which username does it pull from?

Thanks.

[alansidman]

Environ("UserName") pulls the Windows username for the person logged into the particular machine.

Here a couple of other environmental functions you might find useful

http://datapigtechnologies.com/blog/...omainusername/

[calvinle]

Nice one!! Thanks a lot!