Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
How to get system login name
Windows XP Pro
Excel 2002 SP3 Is it possible to get the system login name (if it exists)? I want to do a user check in the workbook open event so I can restrict some sheets from certain edits, based on the user of course. Any help appreciated. -gk- ================================================== ====================== "The creative act is not the province of remote oracles or rarefied geniuses but a transparent process that is open to everyone." -Greg Kot in Wilco Learning How To Die- |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
How to get system login name
are you looking for
Environ("UserName") if Environ("UserName")="My User" then ' code here end if "39N 95W" wrote: Windows XP Pro Excel 2002 SP3 Is it possible to get the system login name (if it exists)? I want to do a user check in the workbook open event so I can restrict some sheets from certain edits, based on the user of course. Any help appreciated. -gk- ================================================== ====================== "The creative act is not the province of remote oracles or rarefied geniuses but a transparent process that is open to everyone." -Greg Kot in Wilco Learning How To Die- |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
How to get system login name
Environ("UserName")
-- HTH Bob Phillips "39N 95W" wrote in message ... Windows XP Pro Excel 2002 SP3 Is it possible to get the system login name (if it exists)? I want to do a user check in the workbook open event so I can restrict some sheets from certain edits, based on the user of course. Any help appreciated. -gk- ================================================== ====================== "The creative act is not the province of remote oracles or rarefied geniuses but a transparent process that is open to everyone." -Greg Kot in Wilco Learning How To Die- |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
How to get system login name
Here is how to access the newtork logon
msgbox( CreateObject("WScript.Network").UserName) "39N 95W" wrote: Windows XP Pro Excel 2002 SP3 Is it possible to get the system login name (if it exists)? I want to do a user check in the workbook open event so I can restrict some sheets from certain edits, based on the user of course. Any help appreciated. -gk- ================================================== ====================== "The creative act is not the province of remote oracles or rarefied geniuses but a transparent process that is open to everyone." -Greg Kot in Wilco Learning How To Die- |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How do I open an Excel file on XP system, saved on a Vista system | Excel Discussion (Misc queries) | |||
How to get system login name | Excel Programming | |||
Login System | Excel Programming | |||
Login System | Excel Programming | |||
excel causing system to be in low system resource | Excel Discussion (Misc queries) |