Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I am restricting sheet access per user based on the following conditional formatting for the sheet:
=Match(QVUser(),'MWENDERA PORTIFA','PORTIFA MWENDERA','CHITEMERERE CHRIS','DEDA BEN','BEN DEDA','MUDZAMI ONESIMOS','ONESIMOS MUDZAMI','MAUMBE CAROL','CAROL MAUMBE','MARANDU NHAMO','NHAMO MARANDU','NDORO PRIMROSE','PRIMROSE NDORO')
This becomes too demanding the higher the number of users. Is there a way to simplify this based on a database load or something else i.e. without having to type each QVUser()?
Regards.
You'll have to initial-data-reduce the values for field View. What you could do is name the flag columns in your security Excel the same as the values in field View (and probably the Sheet labels), and create a reduction table based on these values.
For example with your demo data, User1 would only find View values 'Patents' and 'FDA' in the listbox (aside from the default sheets that everone can see). User2 would find view values 'Generics' and 'Shopping' in that listbox.
Thank you Peter for your input. I will look into that