LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #3   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 523
Default Cell should display, login name.

As far as I know the nearest you can get to Login Name can be give by:

Range("c6").Value = Environ("username")
Range("c7").Value = Environ("ComputerName")

Put these in the worksheet open event.

Sam

"Ranjit kurian" wrote:

I have a excel sheet which is used by five to six people,i need my cell to
view the person name whoever open the excel file, whether its in readonly or
not, it should reflect the person name....

Only the login person name should display not everybodys

 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
making NT user/login user appear in a cell [email protected] Excel Worksheet Functions 1 March 3rd 09 03:41 AM
Conditional display - IF cell is blank, display next used row! Patti[_7_] Excel Programming 2 March 28th 06 10:33 PM
Shortcut key to display change the display from displaying cell values to cell formulae Adrian[_7_] Excel Programming 3 September 14th 04 12:07 PM
Login Box help Bill Lunney Excel Programming 0 August 20th 03 11:45 AM
Login Box Tom Ogilvy Excel Programming 0 August 8th 03 01:42 PM


All times are GMT +1. The time now is 09:35 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"