Past problem: I was unable to implement row level & Sheet level security at the same time: I have 10 sheets(tabs), only 2 of them I do not want to be accessed by certain users. I also want to restrict row level data by zone. Meaning designated sales person in zones should be able to access their corresponding zone sales data. I was able to solve this by using the following script.

Section Access;

LOAD DISTINCT

  Upper(ACCESS),

     Upper(NTNAME) as NTNAME

FROM  qmc;

Section Application;

Star is *;

LOAD * INLINE [

    NTNAME, GROUP, User ID, Zone, SH01, SH02, SH03

    LAPTOP\JDOE, ADMIN, jdoe, A, 1, 0, 1

    LAPTOP\MDIS, ADMIN, mdis, B, 1, 1, 1

];

present Problem:

although the sales persons are supposed to see only their area, I have one metrics where they should be ale to see data across all zones.

This field of restriction is 'Zone'. So now what changes do I need to make in the section access to allow this one metrics with data on all zones  to be accessed by all sales persons, while keeping the restriction by "Zone" on rest of the metrics and sheets.

Please help.