excel - Only make a row visible to a certified person -
i making worksheet people can add issues. want add user access groups in file. i've added column creator of issue has filled in. checking column, excel should determine can see specific row. example:
- group 1 can see everything
- group 2 can see , not issue added group 1
- group 3 can see , not issue added groups 2 , 1
i first thinking of adding different passwords file. according password, excel knows in group user belongs. (for example password "1" people group 1, password "2" people group 2 , ... ) since i'm new using ms office / vba have no idea if possible.
is possible add these passwords or possible make row invisible users depending on input of 1 cell ?
what you're asking possible, not simple. require combination of worksheet protections , own subroutines hide , unhide rows accordingly. need use worksheet protection prevent users manually unhiding rows. then, add userform prompts user password. based on password provided, can unhide specific rows (i recommend using xlveryhidden sheet holds list of rows unlocked passwords). userform should not unprotect sheet, should still able edit hidden property (so recommend using ui protection only)
Comments
Post a Comment