different view

[fc]

Is there a way to have difference view per person in excel?

I am plannig to send out a user name & password sheet to
everyone but how could I restict everyone could only see
his own password?

 

[Charlie]

One way is to use a vlookup function. If sheet2 contains
the names and passwords then in Sheet1 have the employee
enter a Name in A1 and in B1 do a vlookup. Hide sheet2
and protect the workbook. This is not foolproof but it
will keep the honest people honest.

Charlie O'Neill

 

[Marcotte A]

----- Charlie wrote: ----

One way is to use a vlookup function. If sheet2 contains
the names and passwords then in Sheet1 have the employee
enter a Name in A1 and in B1 do a vlookup. Hide sheet2
and protect the workbook. This is not foolproof but it
will keep the honest people honest

I'm not sure how you would do it, but you may be able to access the 'user name' field under Tools -> Options -> General. If you had a fn UserName() that returned the value in that field you could use it in the Vlookup function. Still not totally secure, but slightly more so than Charlie's idea.

 

[Gord Dibben]

Have a look at this google search result.

A thread on passworded user worksheets.

http://snipurl.com/6n5m

Specifically the code provided by Ken Wright.

Gord Dibben Excel MVP