| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
how to deny users macro execution, please?
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 |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
how to deny users macro execution, please?
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 "Cristi@n" wrote in message oups.com... 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 |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
how to deny users macro execution, please?
Try to the logon username
environ("username") -- HTH RP (remove nothere from the email address if mailing direct) "Cristi@n" wrote in message oups.com... 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 |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
how to deny users macro execution, please?
Hi Guys,
Thanks very much! That's exactly what I was seeking for ;-) Ciao, Cristi@n |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Macro Execution | Excel Discussion (Misc queries) | |||
| MACRO execution speed | Excel Programming | |||
| Restricting Macro Execution | Excel Programming | |||
| Restricting Macro Execution | Excel Programming | |||
| automatic macro execution | Excel Programming | |||
Linear Mode
