how to deny users macro execution, please?

[Cristi@n]

Hi group!
Does anyone of you know how to allow macro execution to certain
usernames instead than to everybody? I'm currently using
Application.UserName which can be too easily fooled.
Thank you.
Regards,
Cristi@n

 

[Chip Pearson]

You can get the user's logon name with the following code:

Dim UName As String
UName = Environ("UserName")


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com

 

[Bob Phillips]

Try to the logon username
environ("username")

--

HTH

RP
(remove nothere from the email address if mailing direct)

 

[Cristi@n]

Hi Guys,
Thanks very much!
That's exactly what I was seeking for ;-)

Ciao,
Cristi@n