Cell should display, login name.

's Computer Specifications

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

's Computer Specifications

Operator = Environ("USERNAME")

"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
>

's Computer Specifications

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
Show Printable Version Email this Page
Rate This Thread
Rate This Thread:

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Need cell format to display 025349 as 02-5349 & display 1st zero	msallen	Microsoft Excel Crashes	3	5th Apr 2008 06:19 PM
display last login and unsuccessful login attempts	alps	Microsoft Windows 2000 Security	3	27th Feb 2007 05:28 AM
How to click on a cell and have the content of the cell display in a different cell	marin_michael@yahoo.ca	Microsoft Excel Worksheet Functions	0	6th Jun 2006 03:05 PM
Shortcut key to display change the display from displaying cell values to cell formulae	=?Utf-8?B?QUEyZTcyRQ==?=	Microsoft Excel Programming	3	14th Sep 2004 12:07 PM
Determine Users Login ID & set cell value based on a changed cell	DTM	Microsoft Excel Programming	4	10th Mar 2004 09:19 PM