Home |
Search |
Today's Posts |
#4
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
Hi try this User Define Function
1) Press Alt + F11 2) Select ThisWorkbook, right click and choose Insert then Module 3) Paste the code below into this module Function UserName() As String UserName = Environ("UserName") End Function 4) close the VBE editor 5) Call this function by placing the formula in a cell, eg A1 =UserName() -- Hope this is helpful Pls click the Yes button below if this post provide answer you have asked Thank You cheers, francis "Don" wrote: Within Excel , can it tell you the name of the person who is accessing the file = 1) The name they put in Excel or 2) System Login ID (from NT?) thanks in advance |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
How to retrieve the value? | Excel Discussion (Misc queries) | |||
How to retrieve text within ()? | Excel Discussion (Misc queries) | |||
How to retrieve the value from formula? | Excel Worksheet Functions | |||
Search and retrieve | Excel Discussion (Misc queries) | |||
Retrieve data | Excel Discussion (Misc queries) |