Application.UserName
Hi I have an workbook that is used by many people and som of them hav access to more functions. Therefore I use Application.UserName to who is loged on. If my real name is Carl Something I log on with abcaso but when I use Application.UserName I get "Carl Something" but I want "abcaso" Is it possible to get the name? Thanks in advance *** Sent via Developersdex http://www.developersdex.com *** |
Application.UserName
Use
LoggedOnUser = Environ("Username") -- HTH Bob "kalle" wrote in message ... Hi I have an workbook that is used by many people and som of them hav access to more functions. Therefore I use Application.UserName to who is loged on. If my real name is Carl Something I log on with abcaso but when I use Application.UserName I get "Carl Something" but I want "abcaso" Is it possible to get the name? Thanks in advance *** Sent via Developersdex http://www.developersdex.com *** |
Application.UserName
Hi,
Is this what your looking for MsgBox Environ("UserName") -- Mike When competing hypotheses are otherwise equal, adopt the hypothesis that introduces the fewest assumptions while still sufficiently answering the question. "kalle" wrote: Hi I have an workbook that is used by many people and som of them hav access to more functions. Therefore I use Application.UserName to who is loged on. If my real name is Carl Something I log on with abcaso but when I use Application.UserName I get "Carl Something" but I want "abcaso" Is it possible to get the name? Thanks in advance *** Sent via Developersdex http://www.developersdex.com *** . |
All times are GMT +1. The time now is 08:36 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com