Show row base on Login

[jp16]

Hi, i have a sample cashflow excel. We have different people keying in Payment and Receipt. The balance is Confidential. I want to have a "log in" where Payment people can only view Row 1 (the date) and Row where there is a "P" in Column A. Another "Log in" for Receipt people where they can view only Row with a "R" in Column A. Also, a Log In where it can view everything. Of coz, Payment and Receipt people shd not be able to Unhide row.

Anyone can help?

[PFDave]

Hi jp,

Don't have time to write the whole thing, but a starting point would be this code.

You'd want to create a userform with ID and Password, then use Select Case to decide which user has logged in. Once the relevant line are visible you need to set their protection properties to unlocked which having the remainder of the worksheet locked, then password protect the sheet so they cannot unhide but they can edit the visible rows.

Please Login or Register  to view this content.

[jp16]

I am not that good at userform and vba. Would appreciate if someone can help with a sample excel...