+ Reply to Thread
Results 1 to 3 of 3

How to get system login name

  1. #1
    39N 95W
    Guest

    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. #2
    bigwheel
    Guest

    RE: 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-
    >
    >
    >


  3. #3
    Bob Phillips
    Guest

    Re: How to get system login name

    That is the name define within Tools>Options, user amendable, not the login
    name.

    --
    HTH

    Bob Phillips

    "bigwheel" <bigwheel@discussions.microsoft.com> wrote in message
    news:88113382-5F06-4312-97DE-AD8A46A0CC92@microsoft.com...
    > 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-
    > >
    > >
    > >




+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1