LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #7   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 271
Default userName

I don't know what you are trying to accomplish, but I often use:
Application.UserName

This return the user name of the application (In this case, excel).

Sometimes I only want macros to trigger for certain users and this is how I
set it up. Of course, you have to have them go, in excel, to tools options
general to see how they have their username typed.


--
Thanks
Shawn


"Ronbo" wrote:

Control Panel System = Registered to Ronald L. Lastname
In Excel, Tools Options General = User name: Ronald L. Lastname

Function USER()
USER = Application.UserName
= Ronald L. Lastname

End Function
Function USER2()
USER2 = Environ("UserName")
= Ron Lastname

End Function

Any help on what is going on would be appreciated.
Thanks


 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
(username v1) JJernigan Excel Discussion (Misc queries) 0 June 12th 08 09:13 PM
Username Log PaulJ Excel Discussion (Misc queries) 8 March 1st 06 11:51 AM
Username Alvin Hansen[_2_] Excel Programming 3 September 25th 04 10:36 PM
username libby Excel Programming 8 April 25th 04 03:37 AM
Get NT Username Steven Pugh Excel Programming 7 February 20th 04 09:37 AM


All times are GMT +1. The time now is 10:14 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"