Cell should display, login name.
 

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

Cell should display, login name.
 

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

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