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-

How to get system login name
 

there is a possibility ...

Application.UserName

Test it first with something like

MsgBox "Current user is " & Application.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-

How to get system login name
 

That is the name define within ToolsOptions, user amendable, not the login
name.

--
HTH

Bob Phillips

"bigwheel" wrote in message
...
there is a possibility ...

Application.UserName

Test it first with something like

MsgBox "Current user is " & Application.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-