If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Hide and restrict rows for each user to view his own record only
Source worksheet
[ID] [Name] [Date] [Attend Time] 123 MARY [16-Aug] 09:00 ~ 18:00 124 JOHN [16-Aug] 09:00 ~ 18:00 125 SUE [16-Aug] 09:00 ~ 18:00 123 MARY [17-Aug] 09:00 ~ 18:00 124 JOHN [17-Aug] 09:00 ~ 18:00 125 SUE [17-Aug] 09:00 ~ 18:00 123 MARY [18-Aug] 09:00 ~ 18:00 124 JOHN [18-Aug] 09:00 ~ 18:00 125 SUE [18-Aug] 09:00 ~ 18:00 ...................... ================================================== ========= A user receive this sheet and then he will input ID no. at a cell. [Input ID No.] (Remark: User Mary inputs 123 here) The sheet will display Mary's record only. All other record (rows) will be hide. [ID] [Name] [Date] [Attend Time] 123 MARY [16-Aug] 09:00 ~ 18:00 123 MARY [17-Aug] 09:00 ~ 18:00 123 MARY [18-Aug] 09:00 ~ 18:00 Now I use the filter method only but users can view all records. I want to restrict user to view his record only instead of create user own record sheet for each user. Can I do that? Please help. Thanks |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Hide and restrict rows for each user to view his own record only | Pleo | General Discussion | 6 | August 23rd, 2004 08:01 PM |
Hide and restrict rows for each user to view his own record only | Pleo | General Discussion | 1 | August 23rd, 2004 05:49 PM |